I need to remove about 800 clients out of the database. How can I do this quickly.
Is there anything consistent with those clients that you can search on? If so, just search, then do a Shift+Click on the select all box, and then use a bulk action. But be careful!
Removing records directly from the database requires expertise on DB Administration since there will be a lot of constraints that you have to mind. I would suggest to go for deleting those clients from the web UI...
I have a similar issue. When the WHD service was set up initially we pulled all the accounts in AD into the system. Of course this pulled service accounts and others in to our Helpdesk System, so we have over a thousand clients listed when we only have about half that number that would truly need to be in the system. Going through and deleting individual accounts is a huge hassle, so setting up a way to bulk-delete multiple clients would be a godsend at this point.
I followed this recommendation as far as deleting multiple clients. Luckily, most of the accounts had something in common that I could search for, then it was only a matter of spot-cleaning up any other accounts that were in use.
Thanks for the suggestion IT@cristorebalt.org!
