
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2005 01:19 AM
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?
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?
Labels:
- Labels:
-
Archive
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2005 10:54 AM
This should work

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2005 01:36 AM
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.
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.
