I created a report that show the schedules behind managed software deliveries. I was sick of going through the whole tree to verify all of my policies have different detection and remediation schedules (per Symantec's advice to not have multiple policies detecting at the same time.) I feel this report should have been built in in the first place; there's plenty of other useless reports that can go. /rant
Anyway, I'm a SQL noob so I'm sure someone can improve on this. The performance is pretty slow but it's a big table and it has to parse the xml.