Video Screencast Help

Delete SEP client multiple entries from SEPM

Created: 05 Jul 2013 • Updated: 12 Jul 2013 | 4 comments
SUPPORT-2-SUPPORT's picture
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.

Regards,

S2S

Comments 4 CommentsJump to latest comment

.Brian'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

https://www-secure.symantec.com/connect/forums/sep...

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.

SOLUTION
Chetan Savade's picture

Hi,

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.

http://www.symantec.com/docs/TECH176400

Delete clients not conacted SEPM.JPG

 

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

http://www.symantec.com/docs/TECH93732

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

 

Chetan Savade
Sr Technical Support Engineer, Endpoint Security
Enterprise Technical Support
CCNA | CCNP | MCSE | SCTS |

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?