Details
-
Suggestion
-
Resolution: Unresolved
Description
It would be nice to have a way to see the last login time for users. We have trouble seeing if there are users who no longer use crucible/fisheye yet are still taking up a license.
Workaround
Access the table cru_recently_visited in the database for the history of the last visited repositories, project and reviews:
SELECT cru_user_name,MAX(to_timestamp(cru_last_viewed/1000)) AS "Last Visited Time" FROM cru_recently_visited GROUP BY cru_user_name ORDER BY "Last Visited Time";
Oracle
SELECT cru_user_name,MAX(to_date('19700101','YYYYMMDD') + (cru_last_viewed/1000/86400)) AS "Last Visited Time" FROM cru_recently_visited GROUP BY cru_user_name ORDER BY "Last Visited Time";
A user may still have accessed FishEye through a login and not having an entry in this table.