Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

How to Audit Crucible licenses

Environment:

10,000+ Enterprise Jira, Unlimited Fisheye but only 100 Crucible licenses.

Problem: Product doesn't manage licenses via LDAP and Crucible was autoadded to users that don't need the functionality from previous versions of Fisheye/Crucible.

2 answers

Assuming Your Database is MySQL, run this query against your Crucible/Fisheye database:

select distinct cru_user.cru_user_name,cru_crucible_enabled,from_unixtime(cru_recently_visited.cru_last_viewed/1000) as last_view from cru_user JOIN cru_recently_visited on cru_user.cru_user_name = cru_recently_visited.cru_user_name where cru_crucible_enabled=1 and cru_last_viewed = (SELECT MAX(cru_last_viewed) from cru_recently_visited WHERE cru_user.cru_user_name = cru_recently_visited.cru_user_name) 
UNION
select distinct cru_user.cru_user_name,cru_crucible_enabled,from_unixtime(cru_recently_visited.cru_last_viewed/1000) as last_view from cru_user LEFT JOIN cru_recently_visited on cru_user.cru_user_name = cru_recently_visited.cru_user_name where cru_crucible_enabled=1 and cru_recently_visited.cru_last_viewed is null ORDER BY last_view

This query selects all the users from Crucible and their last login time. The union selects all the users who have crucible enabled but have never logged in. Finally, we sort by date.

You can export the query and have a system admin go in and manually delete users or enhance this to auto delete crucible licenses by setting cru_crucible_enabled to zero.

Figured this was worth sharing, enjoy.


0 votes
Nick Atlassian Team Feb 12, 2014

Brand new in Crucible 3.3 is an Admin REST API for User and Group Management.

You could use the PUT method to toggle crucible access for each user: https://docs.atlassian.com/fisheye-crucible/latest/wadl/fecru.html#d2e187

But last login date isn't available over REST...

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

⚡️NEW Group for Confluence Cloud Admins

Calling all Confluence Cloud Admins!  We created a new Community Group to support your unique needs as Confluence admins. This is a group where you can ask questions, access resou...

112 views 2 9
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