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

Last authentication login details

XMLWordPrintable

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

      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:

            Unassigned Unassigned
            tbomfim ThiagoBomfim (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: