I need help with a script.  I need to get the compliant and non-compliant percentages of the patches for workstations and servers.  I have seen a bunch of posts for this but,  I need it to show only the percentages of the compliant and non-compliant.  I don't know much about SQL code so any help would be great.


0 Comments   [ + ] Show Comments


Please log in to comment


If you go to the patch schedules screen in security you can see the number of compliant and non compliant machines. It even shows a percentage.
Answered 10/26/2015 by: Drave
Senior Yellow Belt

  • I see that but, the Auditors want it in a report.
    • From there you select the schedules you want to be in the report by checking the boxes. Then you go into options and you can export it from there as an excel or csv. Unfortunately, I'm not entirely sure what the fields they use are to make that page. :/ I'd kind of like to make a weekly scheduled report on that too actually. I'm def gonna follow this and let you know if I figure anything out.
Please log in to comment
Answer this question or Comment on this question for clarity