Crucible 4.2.1 - Last Login Query for mysql

We are trying to get a last login report to see who is actually using Crucible.

We were using this Script;

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);

However this worked for Crucible version 3.x...but since we have upgraded we are unable to run this query against mysql.

Instead we get a ERROR 1054 (42S22): Unknown column 'cru_crucible_enabled' in 'field list'

What are we missing.


1 answer

0 vote

Hi Aubrey,

In FishEye/Crucible 4.0 the whole user management has been refactored, see crucible-4-0-release-notes. 

The cru_user.cru_crucible_enabled and cru_user.cru_fisheye_enabled columns have been removed. 

The equivalent is, which tells if user has not been disabled in the directory. However, please note that this column does not tell about global permissions (i.e. access to FishEye and Crucible functionality), which you can check in the following columns:




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...

339 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