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
Article Type
Technical Solution


Subject

Issue



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