Just stumbled on this blog, will try this. Never mind.  :)

http://eskonr.com/2015/08/sccm-configmgr-2012-software-update-compliant-non-compliant-results-for-list-of-computers-from-collection-for-specific-month/

From: [email protected] [mailto:[email protected]] On 
Behalf Of Murray, Mike
Sent: Wednesday, January 27, 2016 2:51 PM
To: [email protected]
Subject: [mssms] Patch report needed

I would like to get a report for a prompted collection that lists each machine 
with patches required, patches installed, and percentage patched, like this:

Name                   Required              Installed               Percent
Machine 1           0                            200                       100%
Machine 2           100                       100                       50%
Machine 3           50                          150                       75%

Anyone have something like this (I'm not great at SQL).  :)


Best Regards,

Mike Murray
Desktop Management Coordinator - IT Support Services
California State University, Chico
530.898.4357
[email protected]<mailto:[email protected]>





Reply via email to