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 ↑