Video Screencast Help

Delete SEP client multiple entries from SEPM

Created: 05 Jul 2013 • Updated: 12 Jul 2013 | 4 comments
This issue has been solved. See solution.

Hi Team,

We have migrated 11000 clients out of 26000 from old 11.x to new SEPM using sylink replace but client entries are still on old SEPM which we need to delete from there. Now we are verifying client one by one and deleting from Old SEPM which taking long time to complete. If anyone having any query which can be run on SQL or any other option is available.

We exported list of systems from both SEPM and collected duplicate using vlookup command in excel.

Please don't suggest to reduce the number of days for non reporting clients.

Thanks in advanced.



Comments 4 CommentsJump to latest comment

ᗺrian's picture

The only other options are to lower the days for non reporting clients (which you don't want) or to do a SQL query.

For the query, I would suggest working with support.

Or you can check a similar query here from Ian_C

Please click the "Mark as solution" link at bottom left on the post that best answers your question. This will benefit admins looking for a solution to the same problem.

Chetan Savade's picture


Thank you for posting in Symantec community.

I would be glad to answer your query.

By default, inactive client records are deleted after 30 days, if inappropriate for your environment this setting can be changed in the Local Site Properties. You can change it to 1 days minimum.

Delete clients not conacted SEPM.JPG

If using SEP 12.1 then location has changed, refer this article.

If have SQL database then results can be achieved using SQL queries.

Chetan Savade
Sr.Technical Support Engineer, Endpoint Security
Enterprise Technical Support

Don't forget to mark your thread as 'SOLVED' with the answer that best helps you.<

pete_4u2002's picture

open a support ticket to check if you can get SQL query to delete the clients?