Uploaded image for project: 'Bitbucket Server'
  1. Bitbucket Server
  2. BSERV-4070

Last authentication login details

    XMLWordPrintable

    Details

    • Feedback Policy:
      We collect Bitbucket feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Description

      As an administrator, I would like to be able to see which users haven't logged in in the past X months.

      Currently you'd have to perform the following query on the database:

      SELECT a.user_name, from_unixtime(b.attribute_value/1000) 
      FROM cwd_user a, cwd_user_attribute b 
      WHERE a.id = b.user_id and b.attribute_name = 'lastAuthenticated'
      AND from_unixtime(b.attribute_value/1000) between '2013-11-05 00:00:00' and CURRENT_DATE();
      

      That would be good if you could also see the details for each user on the screen just like you can do in JIRA:

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              tbomfim ThiagoBomfim
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: