Endpoint Protection

 View Only
  • 1.  Table contain location information in SEP SEM5 database

    Posted Feb 02, 2016 04:57 AM
    Can anybody help me to find the table or view name which content SEP location information in SEM5 database.


  • 2.  RE: Table contain location information in SEP SEM5 database

    Posted Feb 02, 2016 05:09 AM

    I dont remember it as of now, You can check this table

    Symantec Endpoint Protection 12.1.5 database schema
     

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



  • 3.  RE: Table contain location information in SEP SEM5 database

    Posted Feb 02, 2016 05:11 AM

    Do you mean the location configuration that is configured for the group OR the location that is currently set on the clients?

    Anyway, neither of them can be read from the database.

    The group policy is stored in the database as files. Not text.

    The current location of the SEP client is not available in the database. The client only sends the system logs to the SEPM. The system log contains the information about when the location switching happened and to what location the client switched to. It not necessarily has the current location's information.



  • 4.  RE: Table contain location information in SEP SEM5 database

    Posted Feb 02, 2016 05:19 AM

    As a work around, you can build a script to ready the Current location information from each client in the network. Note that the "Remote Registry" service on the remote clients should be started to use such a script to fetch values from remote clients. The location of the String Value to the read is as below.

     

    Name of String Value: CurLocation

    Location of the Value: HKEY_LOCAL_MACHINE\SOFTWARE\Symantec\Symantec Endpoint Protection\SMC



  • 5.  RE: Table contain location information in SEP SEM5 database

    Posted Feb 02, 2016 06:08 AM

    Thanks for the information. Actually I need a single time activity to collect all the location information SEP group-wise.