Uploaded image for project: 'Crucible'
  1. Crucible
  2. CRUC-5789

Add Last login time for users

    XMLWordPrintable

Details

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

    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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              eb31800f18ea Josh Gilmour
              Votes:
              8 Vote for this issue
              Watchers:
              13 Start watching this issue

              Dates

                Created:
                Updated: