How do I create a Report that shows a general summary for all Patch Management executions?
Last Updated April 15, 2014
The Table Evt_AeX_SWD_Execution holds all of the Patch Management execution and status, however it also holds status of Software Management installs. There is a Report that shows Software Execution Summary (Reports > Software > Delivery > Execution Summary).
Is there a way to report on only the Patch Management Executions?
There is, please create a new SQL Report and enter the following data (Default shows the last 30 days.
NOTE: this query shows All Failures, even those that are later successful.