Video Screencast Help

Custom Compliance By Computer Report - Critical and Important Severity Only

Created: 14 Apr 2014 • Updated: 18 Apr 2014 | 2 comments
Preppietechie's picture
+1 1 Vote
Login to vote

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 Computer" 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:


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 Computer - Critical and Important Only".  This report references the stored procedure you just created in step 2.

Note that if you right click on one of the devices and choose "View Applicable Updates" you'll still see all associated updates in that report, but you can easily sort by severity rating.   

Comments 2 CommentsJump to latest comment

adude's picture

Great report!

Thank you!

Andres Ochoa

Altiris Certifed Engineer Client Management Suite 7.1

Symantec Certified Specialist CMS AMS 7.5 SP1 HF2

Login to vote
Preppietechie's picture

Wanted to confirm that this works fine in 7.6.


Login to vote