Endpoint Protection

 View Only
  • 1.  How to export OR view all LDAP BaseDN

    Posted Oct 27, 2014 02:42 AM
      |   view attached

    We have added many LDAP OU into SEPM.But found no way to view or export all of these items. I have to select one by one and click Edit to check the details.How to export them into .csv or check them in embedded DB ? Thanks
     



  • 2.  RE: How to export OR view all LDAP BaseDN

    Posted Oct 27, 2014 02:54 AM

    check the connectdirectoryserver.log under

    C:\Program Files\Symantec\Symantec Endpoint Protection Manager\tomcat\logs



  • 3.  RE: How to export OR view all LDAP BaseDN

    Posted Oct 27, 2014 08:11 AM

    Likely way here is to query the DB, there is no simple way to pull this via the SEPM.



  • 4.  RE: How to export OR view all LDAP BaseDN

    Posted Nov 14, 2014 04:33 AM

    Hi , The connectdirectoryserver.log only gives me exception error.

    Hi Brian, how to query DB, I tried to search but cannot find any filed name with "OU" in all tables.



  • 5.  RE: How to export OR view all LDAP BaseDN



  • 6.  RE: How to export OR view all LDAP BaseDN

    Posted Nov 14, 2014 09:45 AM

    check the SEM_Client table

    OU_GUID char 32     null     OU's GUID if the client is from ActiveDirectory

     

    Navigate to 

    C:\Program Files\Symantec\Symantec Endpoint Protection Manager\ASA\win32

    open the dbisqlc.exe

    user name: dba

    password: database password

     

    Query to get the GUIDs is

    select OU_Guid from sem_client ;
    output to c:\test.csv

     

    from AD you can get the guids using powershell 

     

    http://technet.microsoft.com/en-us/library/ee617236.aspx