Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
HarkinsIT
Champion Sweeper
I was working on pulling some data out of the LANSweeper database with Access and I came across something. I always thought that when you completely delete a computer with the Console that it completely removed it from the database. I just discovered lots of computer info for machines that I had previously deleted in the tblCompCustom table. I'm not sure if its supposed to be there or if it just didn't get deleted automatically when I deleted the computer. Is there any way to easily clean up this particular table (remove all of the deleted computers from it)?

Thanks
-Chris
2 REPLIES 2
HarkinsIT
Champion Sweeper
Perfect. Thank you very much.
Hemoco
Lansweeper Alumni
Use this sql code
delete from tblcompcustom where computername not in (select computername from tblcomputers)

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

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

Try Now