Create
cancel
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

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 votes

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 cwd_user.active, 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:

cru_global_permission.cru_fisheye_user 

cru_global_permission.cru_crucible_user

Cheers
Marek 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Apps & Integrations

How we use Jira Service Management for our recruitment process! - Part 2

It is never about setting up a process and being done with it. Rather, the focus should always be on optimizing it for the best outcomes. Thus, we didn’t stop at setting up JSM for our recruitment pr...

183 views 0 5
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