cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
yves_junqueira
Engaged Sweeper II
Hi again!

I'm testing lansweeper before putting it into production (a few hundred machines environment), and I've run into a small problem.

Whenever I need to rename a computer, what should I do?

It seems that its data is indexed based on the computer name, so renaming would simply make a double-entry.

Is there a way to delete a single computer data from all tables?
2 REPLIES 2
Hemoco
Lansweeper Alumni
This should work
yves_junqueira
Engaged Sweeper II
Running this in query analyser is the best result I got by now:

EXEC sp_msforeachtable @COMMAND1="delete from ? WHERE COMPUTERNAME='blateste'"

I wonder if it's the "right way". Will I be missing any entry I didn't delete.