
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-14-2011 08:52 PM
Is there a way to delete a single computer from lansweeper via batch file? or make a call to a database stored procedure?
Labels:
- Labels:
-
Archive
4 REPLIES 4

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-14-2011 09:26 PM
i used the following command and it worked great... not sure if it cleaned up the other tables.
sqlcmd -U username -P password -d lansweeperdb -Q "delete from tblcomputers where computer = 'computername'"
lansweeper is on our sql database server. if it cleans up the database that will be great, we plan on putting this in our custom actions and using it two ways... one as a straight delete this computer from lansweeper, and to delete the machine before we change the computer name.
Please let me know if there are any other tables that need to have the info deleted.
Thanks
Brian
sqlcmd -U username -P password -d lansweeperdb -Q "delete from tblcomputers where computer = 'computername'"
lansweeper is on our sql database server. if it cleans up the database that will be great, we plan on putting this in our custom actions and using it two ways... one as a straight delete this computer from lansweeper, and to delete the machine before we change the computer name.
Please let me know if there are any other tables that need to have the info deleted.
Thanks
Brian

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-14-2011 10:37 PM
blawson wrote:
Please let me know if there are any other tables that need to have the info
No

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-14-2011 09:08 PM
will data in other tables be deleted automatically? Thanks for the super fast reply!

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-14-2011 08:55 PM
Use sql code:
delete from tblcomputers where computer='computername'
