Number of users who logged in Crucible in last month?

Tarun Sapra Community Champion Oct 29, 2013

hi,

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?

Thanks,

3 answers

1 accepted

2 votes
Accepted answer
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 https://maven.atlassian.com/public/com/atlassian/plugins/fecru-ga/fecru-ga-plugin/1.1/fecru-ga-plugin-1.1.jar and is open source is at http://bitbucket.org/atlassian/fecru-google-analytics/

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.

Cheers,

Nick

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 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 Sign up to answer
Community showcase
Asked Thursday in Jira Ops

I'm John Allspaw, Ask Me Anything about incident analysis and postmortems

I'm John Allspaw, co-founder of   Adaptive Capacity Labs, where we help teams use their incidents to learn and improve. We bring research-driven methods and approaches to drive effective inciden...

2,140 views 8 7
View question

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