Video Screencast Help
As we strive to continually improve your experience on our site, please help us by taking this survey and tell us about your satisfaction level using Symantec Connect. One lucky winner will receive 500 Connect points! * Take the survey.

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