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.