K1000 LDAP User Import
The Helpdesk Imported Users from Windows LDAP., (Worked Well)., But they pulled from the Wrong OU., How do we delete all the users from the K1000 ServiceDesk users and Start over. The OU has 26,000+ users in it! So doing it 150 at a time isn't an option.. Thanks!
Answers (3)
Hello,
This is not possible to delete the user in one shot, you can see the article below.
http://www.itninja.com/question/ad-users-import-questoins
The other way is to connect into the SQL database and use the command "SELECT user_id from" to have the list of users and after DELETE FROM "name of table" where user_id=***
**WARNING** IT IS AN CRITICAL command with no rollback.
Thanks
150+ at a time would be your safe bet.
Deleting them from the USER table directly using a delete SQL would delete the user entry but KACE likes to place things in multiple tables. Deleting them from the USER table doesn't ensure they are deleted elsewhere. There are few things I delete directly from the tables, like custom views from other peoples accounts and the likes.
Hate to say it, but I'd open a ticket directly with KACE for this one. This is exactly why you test your import before you run it. Hindsight is always 20/20.
Our DC has about the same number of accounts and I was always curious what would happen if we did this import. Sounds like it doesn't break anything.
Do you have a K1000? or K1100 or K1200? - Jbr32 11 years ago