Endpoint Protection

 View Only

  • 1.  Report or SQL Query to check the enabled policy option

    Posted Jun 29, 2015 08:40 AM
      |   view attached

    I would like to generate a report to get the groups and the location specific settings of the below mentioned setting to know whether it is enabled or not. Please check the attachment for the reference.

    Clieab-->Settings-->External Communication Settings-->Submissions



  • 2.  RE: Report or SQL Query to check the enabled policy option

    Posted Jun 29, 2015 08:42 AM

    There is no specific report for this.

    You might be able to find it with a query:

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

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



  • 3.  RE: Report or SQL Query to check the enabled policy option

    Posted Jun 29, 2015 08:50 AM

    There is no SQL query matching for my requirement. Is there any query fir this.



  • 4.  RE: Report or SQL Query to check the enabled policy option

    Posted Jun 29, 2015 08:56 AM

    Nothing publicly available...



  • 5.  RE: Report or SQL Query to check the enabled policy option

    Broadcom Employee
    Posted Jun 29, 2015 02:32 PM

    I also believe there is nothing publicly available.



  • 6.  RE: Report or SQL Query to check the enabled policy option
    Best Answer

    Posted Jun 30, 2015 04:31 AM

    You can develope a script to read the below values from the policy.xml file inside each folder (named after the group ID) located at "<SEPMinstallfolder>\Data\outbox\agent" folder. The output of the script can be set record the below values for every group ID in a .csv file

     

    <SubmissionSettings
    UploadLearnedApp="0"
    LockEnableSubmissions="1"
    LockEnableSONARGoodSubmissions="0"
    LockEnableSONARBadSubmissions="0"
    LockEnableReputation="1"
    LockEnableMrCleanSubmissions="1"
    LockEnableAVSubmissions="0"
    LockEnableAVSilentSubmissions="0"
    EnableSubmissions="0"
    EnableStatPings="1"
    EnableSONARGoodSubmissions="0"
    EnableSONARBadSubmissions="0"
    EnableReputation="0"
    EnableMrCleanSubmissions="0"
    EnableAVSubmissions="0"
    EnableAVSilentSubmissions="0"
    ApplyMode="ADMIN"/>



  • 7.  RE: Report or SQL Query to check the enabled policy option

    Posted Jun 30, 2015 04:33 AM

    Just to confirm, the policy/settings of groups cannot be queried from the SQL database as the policy details are stored in the database in excrypted format.