SQL Query to delete computer

[creinking]

Hi,
I am looking to delete about 400 computers from our Lansweeper database. Rather than go through each individual one and click Delete, is there a quick way to do that via a SQL query?

[ChrisS]

My Lansweeper take 6 - 30 secs per PC to delete in this manner, which seemed quite long. (A couple of hours to delete 400 device is not really acceptable when I need to do other stuff with the LS console, which also seems to get very unresponsive while doing these deletes!)

@Lansweeper.... the original question was is there an SQL statement we can run to do this quicker e.g. i sometime want to remove "inactives" or "not scanned". sql query would be far quicker, even if you let us know which tables we need to delete from that would help.

Thanks

Thanks

[Hemoco]

ChrisS wrote:
@Lansweeper.... the original question was is there an SQL statement we can run to do this quicker e.g. i sometime want to remove "inactives" or "not scanned". sql query would be far quicker, even if you let us know which tables we need to delete from that would help.

An SQL query would do the same thing as a deletion performed through the Lansweeper configuration console. The wait times would be the same as well.

[Hemoco]

Some waiting is to be expected at this size, although over a minute does seem long. The wait also depends on the hardware hosting your Lansweeper installation.

[creinking]

7303 computers in our database

[Hemoco]

Deleting may be slower if you have a lot of computers in your database. 75 seconds seems extremely long however. Approximately how many machines are in your database?

[creinking]

Perfect, that works! One thing to note though is that it's taking about 75 seconds per computer to delete. Is that typical?

[Hemoco]

You can delete computers through the configuration console as well. Select the computers you want under Lansweeper\Scanned Computers and hit the Delete button.

You can sort the computers by various parameters to more easily find the machines you need, as shown in the attached image.

[NeilL]

Lansweeper wrote:
You can delete computers through the configuration console as well. Select the computers you want under Lansweeper\Scanned Computers and hit the Delete button.

You can sort the computers by various parameters to more easily find the machines you need, as shown in the attached image.

I'm having a issue where in that when I tried to delete any computer the sqlservr memory goes up extremely.

If I stop lansweeper and sql and restart them the memory use hovers at
sqlservr.exe 250,896 K
LansweeperServices.exe 119,224 K

After I open up Configuration console

sqlservr.exe 1,114,452 K
LansweeperServices.exe 126,816 K

And if I go delete computers i get this

sqlservr.exe 5,725,528 K
LansweeperServices.exe 183,056 K

Any suggestions

[Hemoco]

NeilL wrote:

Lansweeper wrote:
You can delete computers through the configuration console as well. Select the computers you want under Lansweeper\Scanned Computers and hit the Delete button.

You can sort the computers by various parameters to more easily find the machines you need, as shown in the attached image.

I'm having a issue where in that when I tried to delete any computer the sqlservr memory goes up extremely.

If I stop lansweeper and sql and restart them the memory use hovers at
sqlservr.exe 250,896 K
LansweeperServices.exe 119,224 K

After I open up Configuration console

sqlservr.exe 1,114,452 K
LansweeperServices.exe 126,816 K

And if I go delete computers i get this

sqlservr.exe 5,725,528 K
LansweeperServices.exe 183,056 K

Any suggestions

Please contact us at support@lansweeper.com and provide us with a screenshot of your configuration console under Scanning Servers\Your Server\Options. For easy referencing, also include a link to this forum topic in your email.