This forum is for discussion of MySQL database related issues.
Does anyone have a SQL Query that will remove a Client and all their associated information? we had them go offline before we could run the uninstall
- Posts: 5
- Joined: Sat May 07, 2011 2:36 pm
You should just be able to delete/retire the PCs and delete the location and client. The one exception would be if you set a computer to be a probe, since one can't delete a probe; there are forum posts about how to forcibly remove that marker, or v2012 has a script to do that.
- Hero Member
- Posts: 1577
- Joined: Wed Dec 31, 1969 8:00 pm
To make it easier put this in a SQL Execute command in a script.
Call sp_DeleteComputer(%computerid%,'Automatically Removed by script Cleanup Offline Agents. Detected as offline for more than 60Days.')
You can change the wording where it gives the reason.
- Full Member
- Posts: 176
- Joined: Tue Oct 11, 2011 7:28 am
Return to MySQL Database
Who is online
Users browsing this forum: No registered users and 1 guest