How to get a report of policies per agent
| Article:TECH163296 | | | Created: 2011-06-27 | | | Updated: 2011-06-27 | | | Article URL http://www.symantec.com/docs/TECH163296 |
Problem
You want to get a report of the agents assigned to a policy.
Cause
By default this query doesn't exist in the Symantec Critical Server Protections templates.
Solution
You can go in the SCSP Console and use advanced/SQL query and paste the following :
SELECT [objectname] ,[Hostname] ,[IPAddress] FROM [SCSPDB].[dbo].[ASSET_ALLOBJECTS_VW] WHERE objecttype = 'Prevention Policy' or objecttype = 'Detection Policy';
|
|
Article URL http://www.symantec.com/docs/TECH163296
Terms of use for this information are found in Legal Notices
Thank you.