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

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Published in Jira

Admins, notify your Jira instance of system-wide changes with the new admin announcement banner

Hi All! We’re excited to share the launch of an announcement banner that lets Jira site administrators communicate directly to their users across Jira Cloud instance.   📢 Get y...

18 views 0 2
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you