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'