http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspxCustomers at TechEd asked how to generate a compliance report that shows computers that are out of compliance against updates that have been approved for install to them for N days. This can't be done in the public UI because it has no ability to specifyen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3331217Fri, 07 May 2010 20:38:28 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3331217Andrew<p>This seems like some good code. I'm a rookie when it comes to the WSUS/SUSDB. For some reason, there are no values in the my vComputerTarget and was wondering how does the database tables and views get poplulated.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3331217" width="1" height="1">http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3302898Tue, 29 Dec 2009 12:27:55 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3302898araç sorgulama<p>I read Marc’s post about Compliance Reporting and it was similar to a problem I deal with in my job.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3302898" width="1" height="1">http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3302005Tue, 22 Dec 2009 09:05:09 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3302005David<p>In WSUS reports, Bulletin Number does not exist, would you please help on how to run a query to generate a report for &quot;all computers' patch status with Bulletin number&quot;? thanks.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3302005" width="1" height="1">http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3268450Mon, 27 Jul 2009 20:10:53 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3268450söve<p>technet very good. thanks microsoft.. i love you windows</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3268450" width="1" height="1">http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3267458Thu, 23 Jul 2009 14:42:26 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3267458medyum<p>That computer. Howevers it can be done in WSUS 3 and laters via our public SQL view very good</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3267458" width="1" height="1">http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3262212Wed, 08 Jul 2009 17:30:31 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3262212Andy Helsby<p>Come on Microsoft - shouldn't you be checking your blog comments for spam - it's rather worrying that there are so many spam comments on this particular posting (as an example).</p> <p>AS to this post - looks good, it would be nicer if it was easier to create these reports - this looks pretty complicated.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3262212" width="1" height="1">http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3256950Sat, 20 Jun 2009 02:53:00 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3256950compliance<p>I need a sql statement that includes the date (or number of days) of the least recent update on non-compliant servers generated from Marc's sql statement?</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3256950" width="1" height="1">http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3250975Sat, 06 Jun 2009 01:06:57 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3250975sohbet<p>technet very good. thanks microsoft.. i love you windows</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3250975" width="1" height="1">http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3250974Sat, 06 Jun 2009 01:06:15 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3250974chat<p>thanks very good informations.. thanks thanks. nice sites.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3250974" width="1" height="1">http://blogs.technet.com/b/wsus/archive/2008/06/20/baseline-compliance-report-using-public-wsus-views.aspx#3208481Tue, 03 Mar 2009 02:29:20 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3208481Belgesel Tv<p>Yes If a patch or update is installed by some other means than WSUS then &nbsp;WSUS should not return a ‘Not Applicable’ Status</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3208481" width="1" height="1">