Client Management Suite

 View Only

Custom Compliance By Bulletin Report - Critical and Important Severity Only 

Nov 21, 2014 02:50 PM

Credit to ArturoDFW for pointing me in the right direction on this one with his post on Missing report Windows Compliance by Computer - Details in NS7.

I needed a way to get the "Windows Compliance by Bulletin" report to only show data related to updates which have a severity rating of Critical or Important.  If you want to include higher or lower patch severity ratings, you can easily adjust the stored procedure by modifying the following line in the attached SQL querry:

AND   sr.SeverityLevel >=3

Simply modify the "3" to be the minimum patch severity rating you want to include, where:

0=Unclassified
1=Low
2=Moderate
3=Important
4=Critical

Follow the steps below to create the report yourself.

  1. As described above, edit the attached sql querry to include updates matching the desired severity ratings (default is "Critical" and "Important")
  2. Unzip the attached ZIP file.
  3. Run the sql querry against your CMDB
  4. Import the attached XML to create a new report called "Windows Compliance by Bulletin - Critical and Important Only".  This report references the stored procedure you just created in step 2.

Statistics
0 Favorited
0 Views
2 Files
0 Shares
0 Downloads
Attachment(s)
zip file
sp_PMWindows_ComplianceByBulletin_CGM.zip   2 KB   1 version
Uploaded - Feb 25, 2020
xml file
Windows Compliance by Bulletin - Critical and Important Only.xml   44 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Comments

Sep 27, 2017 07:12 AM

 

is not working ,kindly  provide correct one.

Related Entries and Links

No Related Resource entered.