Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Number of users who logged in Crucible in last month?

Tarun Sapra Community Leader 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
Answer accepted
Nick 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 votes
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 Leader 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 Sign up to answer

Atlassian Community Events