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   [ - ] Hide 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?
  • This content is currently hidden from public view.
    Reason: Removed by member request
    For more information, visit our FAQ's.
  • has anyone done deletions from the user table without cleaning up the other user (history etc) tables? any consequences?
Please log in to comment

Answer this question or Comment on this question for clarity




This is not possible to delete the user in one shot, you can see the article below.


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.


Answered 11/08/2013 by: Bertrand_v
White Belt

Please log in to comment

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.

Answered 11/08/2013 by: Wildwolfay
Red Belt

Please log in to comment

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.

Answered 11/12/2013 by: AlanSchmid
White Belt

Please log in to comment