Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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

reddeppa.999@gmail.com's picture

can we add bulletin column to spPMWindows_ComplianceByComputer Stored Procedure.

Please provide the solution?

0
Login to vote
Roman Vassiljev's picture

Hello,

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.

Thanks,
Roman

0
Login to vote