Return to Jive Software

Up to Discussions in Jive Forums

This Question is Possibly Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
457 Views 1 Replies Last post: Nov 6, 2009 4:14 PM by Kevin Imber RSS
dantam12 Novice
dantam12
28 posts since
Aug 24, 2009
Currently Being Moderated

Oct 23, 2009 6:41 AM

Deleting multiple users in the Jive software...

Used LDAP integration to build set of users, unfortunately I think my groups were incorrectly setup and I now have over 3500 users in the system. As I don't have any content in the SBS software at the moment, I want to be able to delete all the users out of the system so that I can start afresh.

 

Can anyone provide suitable SQL script which will do this as I expect that there will be loads of tables affected.

 

If not, the admin GUI gives me ability to remove single users, is there a way I can delete multiples?

Tags: ldap, sql, users, deleting
Kevin Imber Jive Employee
Kevin Imber
293 posts since
Oct 19, 2009
Currently Being Moderated
Nov 6, 2009 4:14 PM in response to: dantam12
Re: Deleting multiple users in the Jive software...

Hello,

 

If you're absolutely sure that there has been no activity by any of your users, then the user data should only be in the jiveuser and jiveusercontainer tables.  So if you just delete all the users but ID=1 (the admin), that should solve your problem.  But also, you could just reinstall?  Hope that helps.

 

Thanks,

Kevin

More Like This

  • Retrieving data ...

Bookmarked By (0)

To better serve our customers we have included functionality to automatically follow up on a case after it has been idle for more than 5 days, and then auto close after an additional 3 days of inactivity. Choose No to acknowledge that this case will remain idle for longer than 5 days.
Making cases public allows other customers to learn from the solution of the case. It can also be used to gain feedback from others in the community. Ask our Support Engineers for more info, but we encourage you to make your cases public.