SCCM Patch compliance report for applicable and missing patch

Hello,
Iam looking a SCCM patch compliance report to generate applicable and missing patches list for each server in a collection. 
report should show all applicable or missing patch KB or msrc no. for each server.
is there any sccm custom report available for the same.
 
Thanks in advance.
 
 

That will be a Huge Report! Just look at the built-in report for 1 system “Compliance 6 - Specific computer”. I look at my site server and there are 191 entries for it alone!
 
This blog post talks about ARP data but you can similarly see how much data is going to be within the report. Just two system will be 5 pages!
 
Try this report, it is nice and simple. http://smsug.ca/blogs/garth_jones/archive/2009/02/25/patch-compliance-progression-report.aspx

See the web report I added a while ago. http://www.myitforum.com/Forums/tm.aspx?high=&m=230497&mpage=1#230658
It runs the report per collection so just make a collection of servers only.  It doesn't break it down by server.  If you want that it will be an enormous amount of data like gjones mention.  Its similiar to asking to see all software installed on every system.  Here's a 30,000 page report ;P
 
I just recently used it at a couple customer sites and it works like a champ.  Only for ASP classic reports.  The multiple select statements need to be removed to work with SRS.

you can also try this;
http://anotherblabla.wordpress.com/2013/03/17/sccm-software-update-compliance-report/
it will give you the % of compliance by selected update classifications as well as the detail by servers