I have a 2006 Nissan Pathfinder that I bought with a mildew interior and full of water. I found 2 leaks. One was the sun roof drain tubes and the other was the rear driver side door for the back seat due to it being warped. I'll attempt to attach pictures but it always seems to fail so you might have to copy and paste the link. But in order to unclog the sunroof drain tubes the headliner has to be removed which wasnt a problem for me since I already had the rest of the interior ripped out due to mildew and mold.
https://imgur.com/a/BIYioTS
My Pathfinder has four of these drain tubes and how you unclog them is to pull them off the plastic sun roof gutter nipple and take a pressurized water source like a water hose with one of those selectable nozzles so you can set it to jet and put it up against this tube and thoroughly flush it out for a few minutes. You will be surprised on how much trash will come out. Repeat this for all four tubes. Then make sure the nipples where the hose connects is also completely clean. Wipe out the gutter with a wet paper towel as much as you can and then take an air compressor and blow out each of the nipples to make sure they are completely free of any debris.
With the right tools and patience this can be done by one person in one day.
Also check for warped doors just take a water hose and put the selector nozzle on shower mode and thoroughly spray each door at the top including the back hatch and see if any leaks inside the vehicle. On mine it only took a sight warp in the door to make a waterfall inside. Luckily this is a cheap and easy fix just go to Lowe's and buy the purple pack of weather stripping and run it across the top of the door jamb where the top outer most seal meets so that when you close the door the two pieces of weather stripping smash together and make a rainproof seal that will never leak again. I know double gasketing is a sin but in this case it's a blessing.
Another quick test to see if your sun roof may be leaking is a water stain at any low spots on your headliner and a way to see it is to pull the inner most door gasket loose and back then shine a bright flashlight inside and see if you can find a rubber tube. If it's covered in condensation or has drops of water hanging from it then it's a good chance it's clogged and over flowing/leaking.
I hope this helps. Btw parking under a tree or in a really dusty environment followed by frequent rain showers seems to cause these drain tubes to clog up faster.