Report for scheduled Deployment

Hi,

I have set up a schedule to install multiple packages for around thirty desktops on a monthly basis. I can see that only half of these completed successfully as desktops were switched off (despite asking people to leave them on!). As a result I am trying to write a simple single report which will show the collective results of the installs and the respective failures. In otherwards a list of Host Names, Success/Failure for each package and the reason for failure. Useful to have the percentages of success rate as are in the built in report.

The only way I can see this information at the moment is to generate a deployment report on each individual package within the schedule which is not practical. This is also presented in such a way that it is not easy to view a quick list of the failed hosts due to the formatting used. I am surprised that there is not already the report I am looking for. Anyone else set up something similar before I go digging into SQL reports?

thanks in advance