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.
select [Status] =CASE when e.status = 'Command executed' then 'Success'
when e.status = 'Failed' then 'Failed'
when e.Status = 'Terminated' then 'Terminated'
End, COUNT ([Status]) as 'Count'
from Evt_AeX_SWD_Execution e
where e._eventTime > GETDATE() – 30 -- Count Executions from last XX Days
and PackageId in (select distinct ItemGuid from [Evt_NS_Item_Management]
where [ItemClassGuid] = '6E89DC4B-693A-4BD3-AEFA-385CCD1874E8') -- Patch Solution Class GUID
group by [Status]
order by 2 desc