/build/static/layout/Breadcrumb_cap_w.png

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! 


2 Comments   [ + ] Show comments
  • I would contact support and ask for assistance.

    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 10 years ago
  • has anyone done deletions from the user table without cleaning up the other user (history etc) tables? any consequences? - tholmes 9 years ago

Answers (3)

Posted by: Bertrand_v 10 years ago
White Belt
0

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

Posted by: Wildwolfay 10 years ago
Red Belt
0

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.

Posted by: AlanSchmid 10 years ago
White Belt
0

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.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ