Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How do I count how many Crucible Users I have?

KC_Baltz October 31, 2014

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.  

4 answers

1 accepted

1 vote
Answer accepted
user1648639125013
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 2, 2014

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 November 3, 2014

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

Like Peter Rawlings likes this
1 vote
Madhu Vanam
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 14, 2017

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 8, 2020

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

0 votes
Gerald Schneider
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 8, 2020

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

 

0 votes
makareswar rout
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 26, 2016

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

 

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events