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:

        1. User_Jira.png
          User_Jira.png
          48 kB

            [BSERV-4070] Last authentication login details

            Johan Lambov added a comment -

            can the equivalent MS SQL query be provided too please....

            Johan Lambov added a comment - can the equivalent MS SQL query be provided too please....

            Devtools Barclays added a comment -

            can the equivalent MS SQL query be provided too please....

            Devtools Barclays added a comment - can the equivalent MS SQL query be provided too please....

            Lee Pickhaver added a comment -

            can the equivalent MS SQL query be provided too please....

            Lee Pickhaver added a comment - can the equivalent MS SQL query be provided too please....

            Roger Barnes (Inactive) added a comment -

            I think the documented workaround is sufficient for the time being. We may revisit this another time.

            Roger Barnes (Inactive) added a comment - I think the documented workaround is sufficient for the time being. We may revisit this another time.

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

                Created:
                Updated:
                Resolved: