Endpoint Protection

 View Only

  • 1.  SQL Query for Mapping Groups against Policies

    Posted May 30, 2015 05:06 AM

    I am a looking for a SQL query for mapping Groups against the policies that are configured for that group.

    This is available as a report on SEPM console in Reports -> Audit Reports.

    The report that is generated is not something that can be worked with.

    I tried to extract the SQL query for this report using "https://www-secure.symantec.com/connect/articles/extract-sepm-reports-clear-sql-query-step-step-process". Unfortunately this was not successful.

    Does anyone have a SQL query that would be able to do the output in a tabular manner?



  • 2.  RE: SQL Query for Mapping Groups against Policies

    Posted May 30, 2015 05:41 AM

    here is some SQL query

    SebastianZ articles

    https://www-secure.symantec.com/connect/articles/compilation-sql-queries-sepm-database

    https://www-secure.symantec.com/connect/forums/sql-querys-database

    Symantec Endpoint Protection 12.1.6 database schema

    https://support.symantec.com/en_US/article.DOC8633.html



  • 3.  RE: SQL Query for Mapping Groups against Policies

    Posted May 30, 2015 06:53 AM

    Thank you for the links.

    I had gone through those links. Unfortunately, being a novice at SQL I was not able to get the narrow down to query that I require.

     



  • 4.  RE: SQL Query for Mapping Groups against Policies

    Posted May 30, 2015 08:33 AM
    My suggestion would be to contact support as they can help you create one.


  • 5.  RE: SQL Query for Mapping Groups against Policies

    Posted May 30, 2015 09:16 AM

    I have done that too. Will paste it here if I get a reply from them.

    In case anyone haves it handy, it would be real helpful.



  • 6.  RE: SQL Query for Mapping Groups against Policies

    Posted May 30, 2015 09:29 AM

    Sounds great.....Cheers!



  • 7.  RE: SQL Query for Mapping Groups against Policies

    Posted Jun 03, 2015 10:09 AM

    Got an update from Symantec Support - they will not be able to assist on this. :(

    I hope some one else would have had this requirement at some point of time and developed some thing to get this done.

    Please do share.



  • 8.  RE: SQL Query for Mapping Groups against Policies

    Posted Jun 08, 2015 06:55 AM

    Would appreciate if anyone could help on this.