Number of users who logged in Crucible in last month?

Tarun Sapra Community Champion Oct 29, 2013


Are there REST API calls available to determine the number of unique visitors to the crucible instance for a specific time period?

or is there an alternate way to achieve this functionality?


3 answers

1 accepted

2 votes
Nick Pellow Atlassian Team Oct 30, 2013

I just created a small plugin for you which will inject Google Analytics into your FishEye/Crucible instance.

The plugin can be downloaded via and is open source is at

Once installed, refresh the admin screen and click on the Google Link in the Global Settings.

From here you can configure your Google Analytics tracking ID.



1 vote
Jeff Thomas Atlassian Team Oct 29, 2013

Tarun: I don't see any timestamp that is updated when user logs in, but Crucible does store information about the last repository, user, review, and project that someone visits. Using that data, I was able to write a query to get the total number of unique users between two dates. The query below is written for Oracle, so you'll need to tweak it for the database that you're using.

select count (distinct cru_user_name) as total_active_users
from cru_recently_visited
where trunc(DATE '1970-01-01' + (cru_last_viewed/1000/86400)) between DATE '2013-09-01' and DATE '2013-10-01';
Jeff Thomas Atlassian Team Oct 29, 2013

If there is a way to include Google Analytics, that might be the easier option. I'll keep looking to see if that's possible.

0 vote
Jeff Thomas Atlassian Team Oct 29, 2013

You could use Google Analytics to get this data. Below are some links that talk about setting up Confluence with Google Analytics.

Report Confluence Activity Using Google Analytics in the Wiki

Measure Your Wiki’s Activity with Google Analytics for Confluence

Tarun Sapra Community Champion Oct 29, 2013

it's crucible not confluence, do you mean to use confluence integration with analytics as a dummy?

Suggest an answer

Log in or Join to answer
Community showcase
Bridget Sauer
Published Mar 09, 2018 in Jira Service Desk

E.L. Fridge's take on education, Jira Service Desk, and creative Jira use cases

...word of mouth, so by 2016, we were working with several other entities on campus to implement Jira Service Desk . The Atlassian motto of “for every team” has really come true for us in this case. We...

337 views 0 9
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot