Looks like you have a great start with the query. What I'd do personally is to set up an alert for this.
Put all of the details concatenated into column 1 of the select, then a case statement of success or failure based on the status (since this needs to be a numeric).
You can then be notified if the case statement evaluates to False or failure for the alert.
The reason I'd recommend going this route is that the report functionality regarding this type of report would really just be the query itself against the monitored instance.
This way you could leverage DPA to get notifications when things fail.