Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
elliottb
Engaged Sweeper
After permanently deleting computers via the console I have found that it does not remove them from the tblADcomputers. Is there a way to make sure when they are deleted from the console that it deletes them in this table also or do I have to manually delete them from tblADComputer? I am running version 3.5.048.
1 REPLY 1
Hemoco
Lansweeper Alumni
try this sql code:

delete from tblADcomputers where computername not in (select computername from tblcomputers)

General Discussions

Find answers to technical questions about Lansweeper.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now