I stole (sorry, borrowed) the attached query from a sql profiler of a report run in the way you describe.
The columns aren't named exactly as in the report, and you will also need a way of chaning the group ID to match the ones you are creating but it is a step closer to what you need. unfortunately, there isn't really a way of automatically publishing the report you want, so you need to find a different way using a query similar to this.
Mark Star - MarXtar LANDesk Enhancements
Home of Power State Notifier & Wake-On-WAN for LANDesk
vulquery.txt 531 bytes
Looks good. i will give it a try.