I thought I remembered seeing this in the interface somewhere, but now I can't find it. How do I know how many users have access to Crucible without manually counting them? I'm trying to see how close to the license limit we are.
Hi,
You can find the number of active Crucible Users by running the following SQL command against the database;
select count(*) as total_cru_users from cru_user where cru_crucible_enabled = true;
Kind Regards,
Chris
If you have admin privileages, navigate to:
Administration -> System settings -> System info -> License
license restrictions should give the number of users using crucible.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In my case (unlimited users) there is no number of users displayed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My solution for FishEye/Crucible 4.8.1 with Crowd:
Run
SELECT `id`,`directory_name` FROM `cwd_directory`;
to get the directory ID (in my case 2)
Then run this query to get the count:
SELECT COUNT(distinct `user_name`) FROM `cwd_user` WHERE `directory_id`=2 AND `active`='T';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you are using crowd : Please run the below qry.
select count(*) from cwd_membership where lower_parent_name='fisheye-users';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.