Endpoint Protection

Need script to delete Offline SEP agent entries in the SQL database .

We have SEPM server name for ex (ABC) and database server is (DEF) and database is sem5.

As we have multiple VM's in the environment , having lot of offline entries are created in the SEPM . Due to this manual remediation/deletion is needed on daily basis.

Can any one help me with the sample script which can delete the entries in the SQL database.

Thanks

Why don't you just set the purge in SEPM to 1 day?

How to configure the number of days after which inactive clients are deleted from the SEPM database.

Is any sample script is available ?

I've not seen a newer one for SEP 12.1 or 14. 

You can make this change from the SEPM though. There is no script needed to do it.

Hello Manikandan,

Here is the script

https://www.symantec.com/connect/articles/how-delete-particular-computers-sepm-mssql-database

@Manikandan

Test the script first. It is seven years old, and while it doesn't specify version, this was before SEP 12.1 or 14.

Yeah test it, it references SEM_Client and SEM_Agent, These two exists on all the versions of SEP