How do I count how many Crucible Users I have?

[KC_Baltz]

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.  

[user1648639125013 · Accepted solution]

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

[KC_Baltz]

That worked, but I'm disappointed there isn't a way to view this in the web interface.

[Madhu Vanam]

If you have admin privileages, navigate to:

Administration -> System settings -> System info -> License 

license restrictions should give the number of users using crucible.

[Gerald Schneider]

In my case (unlimited users) there is no number of users displayed.

[Gerald Schneider]

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'; 

[makareswar rout]

If you are using crowd :  Please run the below qry.

select count(*) from cwd_membership where lower_parent_name='fisheye-users';