Is there any tool or SQLquery to get the details of shared and non-shared policy in the SEPM like to know how many policies exist and their details.
You can run a report for this
Go to the Reports page
Set report type to Audit
Set select a report to Policies
Select Create Report and it will show you on the right hand side whether the Policy is shared or not.
what report
I dont think you will be able to get that report. its still under the ideas section
I can get that report as brain said. Thank you very much guys
Awesome, happy to help.
Really a good question and good answer, this forum rocks :) Cheers!!!!
SEPM is not giving the complete report. It gives only for few groups and not for all groups. SEPM sucks
What do you mean? I run the report monthly and it shows all the groups. If you have multiple domains, you can select which one but otherwise it does a query against all groups.
I have only one domain and it is not giving all the group information.
Do we have any query to get this from SQL since the SEPM is not querying all the groups
Nothing specific but there are a ton of queries here which may be useful
https://www-secure.symantec.com/connect/articles/compilation-sql-queries-sepm-database