ConfigMgr SQL queries for helping the IT Pro report on KBs related to MS17-010

Pre-Windows 10 machines: Windows Vista and Server 2008 SP2: KB4012598 Windows 7 and Server 2008 R2 SP1: KB4012212 Windows Server 2012: KB4012214 Windows Server 2012 R2 and Windows 8.1: KB4012213 -- For Windows 7, Server 2008 R2 SP1, Windows Server 2012, Server 2012 R2 and Windows 8.1, Windows Vista and Server 2008 SP2 -- This... Continue Reading →

Advertisements

How to find quick compliance percentage of Patch MS17-010 in your environment?

select catinfo.CategoryInstanceName as Vendor0, ui.ArticleID as ArticleID, ui.BulletinID as BulletinID, ui.Title as Title, NumPresent as Present, NumMissing as Missing, NumNotApplicable as NotApplicable, NumUnknown as Unknown, NumTotal as Total, PCompliant=convert(numeric(5,2), (isnull(NumPresent, 0)+isnull(NumNotApplicable, 0))*100.0 / isnull(nullif(NumTotal, 0), 1)), PNotCompliant=convert(numeric(5,2), (isnull(NumMissing, 0))*100.0 / isnull(nullif(NumTotal, 0), 1)), PUnknown=convert(numeric(5,2), (isnull(NumTotal - (isnull(NumPresent, 0)+isnull(NumMissing, 0)+isnull(NumNotApplicable, 0)), 0))*100.0 / isnull(nullif(NumTotal, 0), 1)),... Continue Reading →

Create a free website or blog at WordPress.com.

Up ↑