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)