Video Screencast Help

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.

 

 

iddqd idkfa idclip