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

Resource Policy Summary SQL

Created: 11 Nov 2013 • Updated: 13 Nov 2013 | 1 comment

I need to write a report that shows the active policies assigned to a computer. More or less show what is on the "Resource Policy Summary" page. What table(s) is this stored in?

Operating Systems:

Comments 1 CommentJump to latest comment

Igor Perevozchikov's picture

Hi noodleNT,

1. You'll need to find a ResourceGuid of computer which "Policy Summary" data you want to see in custom report.

2. Take this Query and specify ResourceGuid for @ResourceGuid

exec spRMGetPolicySummary @ResourceGuid='',@Attributes=1,@Culture=N'en-US'

3. Open Symantec Management Console -> go to Reports -> mouse right click menu -> New -> Report -> "SQL Report" ->

-- Set your query

SQLReport1.JPG

-- Save Changes

-- Now you have custom report which shows "Summary Policy" information for required computer.

SQLReport2.JPG

Thanks,

IP.

  1. Don't forget that, first you can find an answer for your question in Knowledge base
  2. If answer solves your question, then please mark as solution to close a thread