Resource Policy Summary SQL

[Migration User]

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?

[Igor Perevozchikov]

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

 

-- Save Changes

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

 

Thanks,

IP.