Lyonel Posted February 26, 2018 Share Posted February 26, 2018 Hi, Is there a way to quickly archive properly 600+ users? Link to comment Share on other sites More sharing options...
Dan Munns Posted February 26, 2018 Share Posted February 26, 2018 You could use the LDAP tool if all the users still exist and are set to disabled in AD. Link to comment Share on other sites More sharing options...
Steve Giller Posted February 26, 2018 Share Posted February 26, 2018 Or if they're in the same OU, even. Link to comment Share on other sites More sharing options...
Lyonel Posted February 26, 2018 Author Share Posted February 26, 2018 Can't use the AD... The root cause is that these 600+ accounts have not been disabled then deleted from the AD; but simply deleted (not respecting our internal process!). So now I am left with 600+ user accounts in Hornbill that I would like to Archive. Link to comment Share on other sites More sharing options...
TrevorKillick Posted February 26, 2018 Share Posted February 26, 2018 @Lyonel Changing a user status to archived could be done with a simple SQL Update via Direct DB in the Admin Tool. h_sys_accounts.h_account_status = 2 The above will archive a given user, of course doing this comes with the usual caviates of make sure you check the SQL statement only updates the accounts you want archiving. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
Steve Giller Posted February 26, 2018 Share Posted February 26, 2018 Ignore me - Trevor is already there! 1 Link to comment Share on other sites More sharing options...
Lyonel Posted February 27, 2018 Author Share Posted February 27, 2018 @TrevorKillick are you sure it is 3? From the records I have, it seems to be 2. Link to comment Share on other sites More sharing options...
Steve Giller Posted February 27, 2018 Share Posted February 27, 2018 Just now, Lyonel said: @TrevorKillick are you sure it is 3? From the records I have, it seems to be 2. Looking in my data, it does seem to be 2 for me as well. Link to comment Share on other sites More sharing options...
TrevorKillick Posted February 27, 2018 Share Posted February 27, 2018 @Lyonel @DeadMeatGF Sorry yes its 2 NOT 3 ... My bad. Kind Regards Trevor Killick Link to comment Share on other sites More sharing options...
Lyonel Posted February 27, 2018 Author Share Posted February 27, 2018 Thank you @TrevorKillick ! I know it is not recommended to do SQL updates, but I cannot see any other solution here... Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now