Problems with water intrusion after hard rains showed up in my roof vents and dripping down the A Pillar on the passenger side. Local dealer was of no help.

I checked the sunroof, and the little weep/drain holes were not draining when I poured a cup of water in the channel. They are really hard to get to, stuck way in the corners behind sunroof hardware, and very small.....
Solution: put a piece of rubber tubing in a pencil sharpener at one end to made a conical end to fit in the weep holes. Attached other end to reducer on end of my compressor hose. Blasted the holes with air.
Both sides drain fine now............A few more hard rains will be very telling,,,