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

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

Hi Liane,

Did you already removed the PCs that are no longer on the network from the SEC by right-clinking on them and selecting "Delete"?

Cheers,

V

Hi

I did consider that but wasn't sure if they would just come back again.

Thanks

Liane

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

It depends on your set up and other factors, but normally they shouldn't come back. If they do then you can look at your set up and alternatives ...

i would like to see a feature built in to Sophos Central that allows computers that have been inactive for 6 months or so to be deleted automatically.

Hello aspenman -

Please submit a new product enhancement request, or vote on an existing request related to what you would like included in Sophos products.

Requests submitted here are reviewed by Sophos Product Management, and the more visibility it has, the better.

Many thanks,