Message Image  

Endpoint Protection

 View Only
  • 1.  How to clean the database ?

    Posted Oct 07, 2010 11:34 AM

    Hi,

    I would like to know if is it possible to clean the database ?

    To be more precise, in SEPM console when I click on the red cross in order to have details on the security's status (pic1), the statistics (pic2) are false because there are computers who aren't clients of SEPM, and on the network anymore.

    Pic 1

     

    Pic 2

     

    Regards,

    JL



  • 2.  RE: How to clean the database ?

    Posted Oct 07, 2010 11:38 AM

    Yes , we can purge the database from SEPM.

    Symantec Endpoint Security Manager: How is Database Maintenance scheduled? 

    http://www.symantec.com/business/support/index?page=content&id=TECH95880&locale=en_US

     

    Changing the log settings to reduce the size of the database

    http://www.symantec.com/business/support/index?page=content&id=TECH105238&locale=en_US

     
    How to quickly purge the SEPM log tables on a SQL server

     



  • 3.  RE: How to clean the database ?

    Posted Oct 11, 2010 09:16 AM

    Yes ; that can be done

    Refer Pete's solution on this discussion

     

    https://www-secure.symantec.com/connect/forums/how-remove-sep-client-sep-manager



  • 4.  RE: How to clean the database ?

    Posted Oct 11, 2010 09:16 AM

    Ok, I think the solution should be :

    Yes , we can purge the database from SEPM.

    Symantec Endpoint Security Manager: How is Database Maintenance scheduled? 

    http://www.symantec.com/business/support/index?page=content&id=TECH95880&locale=en_US

    But :

    My groups are synchronised with the AD. So I don't manually delete the clients.

    Consequence, when a computer is deleted in the AD, and SEPM synchronize with it, it don't put in the database SEM_AGENT.DELETED to 1.

    So to clean the database, is the best way to set DELETED from SEM_AGENT's table to 1 ?

    Regards,

     

    JL