Video Screencast Help
Symantec Secure Login will be live on Connect starting February 25. Get the details here.

Add Severity Column to spPMWindows_ComplianceByComputer Stored Procedure

Created: 22 Oct 2010 | 2 comments
DavidAJLockwood's picture
2 Agree
0 Disagree
+2 2 Votes
Login to vote

The spPMWindows_ComplianceByComputer stored procedure included a parameter for severity in version 6. In version 7 this is missing. Can we add this again.

It would be possible to modify the stored procedure manually with a new join and group by clause but it would be better to add this functionality to the product.

Comments 2 CommentsJump to latest comment's picture

can we add bulletin column to spPMWindows_ComplianceByComputer Stored Procedure.

Please provide the solution?

Login to vote
Roman Vassiljev's picture


In case if you need to know compliance status of some bulletin on each computer, you may check it using Compliance by Bulletin report:
1. Navigate to Compliance by Bulletin report
2. Right-click required bulletin and select View Applicable/Installed/Not installed Computers by bulletin
3. Drilldown report will be opened with the list of computers.


Login to vote