Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
cheche
Champion Sweeper
Hi,
Is there any stored procedure to permanently delete a computer?
3 REPLIES 3
cheche
Champion Sweeper
Yes, deleting in cascade solved my problem. Thanks.
cheche
Champion Sweeper
I've found this:

==========================================
DGoodwin wrote:
I just looked in a couple of my tables where Computername = what we removed via the tool, and I do not see any reference to the removed in the following tables (tbl_software, tbl_OperatingSystem, tbl_ComputerSystem, tbl_Users). It look as if it does remove all data. Maybe LS can clarify if removing a machine from tbl_computers will strip out that machine from the rest of the tables?

Yes, when you delete a computer from tblcomputers it is cascaded to the other tables.
==========================================

Hemoco
Lansweeper Alumni
You can permanently delete computers from the configuration utility.

In sql code you can launch

delete from tblcomputers where computername='yourcomputer'

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