Showing results for 
Show  only  | Search instead for 
Did you mean: 
Engaged Sweeper

I was wondering if there was a way to delete 1500+ computer that belong to a certain domain through the back end (SQL Script). The reason why I'm asking is it taking an average of 2 minutes to delete a computer using the Lansweeper Configuration and when ever I do that sql server just eat the crap out of my memory going from say 4 Gb to up 7.5 Gb bring the server down to a crawl. Nobody can then access the lansweeper from the web.

Any help in this would be great.

Thanks Neil
Lansweeper Alumni
Is your sql server set to "full logging" if yes, change it to "simple", this will make it a lot faster.

SQL script:

delete from tblcomputers where domain = 'mydomain'