Remove PC's no longer on network

Hello,

You can use our PurgeDb tool that should allow you to delete old computers from SEC database :

https://community.sophos.com/kb/en-US/110733

Best Regards

Hello,

You can use our PurgeDb tool that should allow you to delete old computers from SEC database :

https://community.sophos.com/kb/en-US/110733

Best Regards

Hi Geoffrey,

Thank you but it says it will not work on 64-bit operation systems and we are running on an SBS 2008 system which is 64-bit.

Thank you

Liane

Hello,

Try this then : https://community.sophos.com/products/endpoint-security-control/f/16/p/523/18834#18834

This not officially supported and you should run a backup before using it. But this will delete old computers directly from your database.

sqlcmd -E -S .\sophos -d sophosXX -Q "delete from computersanddeletedcomputers where managed=1 and lastmessagetime<'MM/DD/YYYY'"

.\sophos = is your SQL instance (by default Sophos)

sophosXX = is your Sophos Database. Depending on your Enterprise Console version XX can change.

If your not sure about this check this article : https://www.sophos.com/en-us/support/knowledgebase/17323.aspx

Another command is : 

sqlcmd -E -S .\sophos -d sophosXX -Q "delete from computersanddeletedcomputers where managed=0'

but you Have to delete in your console all the computers you want to remove from your Sophos Database, then run the command.

Of course, backup your database before running such command.

Hope this will help

Best Regards

Hello Liane,

it says it will not work on 64-bit
dunno why the article says so - IIRC this was the case when the tools was initially released. Runs on my 2008R2 so ... Don't forget to backup the database and stop the Management Service.

Christian

Hi Christian

Thank you for confirming that.

Liane