How to get a report of policies per agent

Article:TECH163296  |  Created: 2011-06-27  |  Updated: 2011-06-27  |  Article URL
Article Type
Technical Solution



You want to get a report of the agents assigned to a policy.


By default this query doesn't exist in the Symantec Critical Server Protections templates.


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

Terms of use for this information are found in Legal Notices