A few hours only past since my first post  on this matter, but there's nothing like Connect to keep the momentum.
So this evening I have 3 elements to add to the project:
- The generic SQL query to summarise the content of the SWD Execution table
- The houlry exec count per Advertisement Name
- A sample page with a chart to validate the basic look and feel
SQL Query I:
The first query I ran is very simple: list all the software delivery execution in the event table by run count. Order the result by count descending, and lilmit the data set to 100 results, albeit we could limit the dataset to any policy that has more than n execution just as well:
select top 100 AdvertisementName , COUNT(*) as '#'
group by AdvertisementName, AdvertisementId
order by COUNT(*) desc
Note that we use the AdvertisementId field in the group by as a safety measure, in case we...