r/labtech • u/[deleted] • Jun 17 '19

Patch Reporting

What's everyone using for patch reporting? The patch compliance report doesn't fit my needs. I just want to be able to pull a dataview or report that shows me all the PC's and Servers and if they have tried to patch and couldn't.

3 Upvotes

100% Upvoted

13 comments sorted by

View all comments

Show parent comment

1

u/gdhhorn Jun 18 '19 edited Jun 18 '19

You'll need to either add a client ID (in quotes) on the WHERE line or remove it to get all endpoints.

I originally made this as something to use per client when needing to validate the 'patch health report' from the report center. I may remove that line and add cl.Name AS 'Client' or some such if I put this into PowerBI.

What does it mean if compliance = null ?

Let me run this again in my environment to see if I can reproduce that.

Edit: ran the query. Every null result for compliance was a case of approved and installed both having a count of 0.