→ 🚀Are you a Lansweeper Champion?! Join our Contributor Program Sign up here!

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)