Uploaded image for project: 'Identity'
  1. Identity
  2. ID-8243

Store user creation date, last update, last log date in the user table.

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

      NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.

      There's no way to build usage indicators with current user access information.

      • It would be very helpfull for security purpose, such as "remove access to users that does not access to jira since 90 days".
      • It would be very helpfull for reporting indicators, such as the number of new user per month.

            [ID-8243] Store user creation date, last update, last log date in the user table.

            We need important information how much customers with Atlassian managed account (users) were created the last month.

            How to get such a list? 

            There is no way at the moment to see the creation date on user details - neither from Jira UI or using the REST API.

             

             

            Anna Momkova added a comment - We need important information how much customers with Atlassian managed account (users) were created the last month. How to get such a list?  There is no way at the moment to see the creation date on user details - neither from Jira UI or using the REST API.    

            alon-sabi added a comment -

            Seriously? no way to get the created at / updated information? . I need to get when users were created and when they were deactivated. Even the audit log does not seem to have that. I can see that "someone" was deactivated / created but I cannot get the account id associated with the change. HELP

            alon-sabi added a comment - Seriously? no way to get the created at / updated information? . I need to get when users were created and when they were deactivated. Even the audit log does not seem to have that. I can see that "someone" was deactivated / created but I cannot get the account id associated with the change. HELP

            I too would like this.. c'mon Atlassian!  

            Tommy Minahan added a comment - I too would like this.. c'mon Atlassian!  

            Poke

             

            Would love to see this.

            Joe Pakenham added a comment - Poke   Would love to see this.

             

            url = "{}/admin/rest/um/1/user?username={}&expand=attributes".format(JIRA_BASE_URL, quote(user_name))
            

             
            returns a json representation of the user, with extended details. createdDate attribute contains the user creation date in epoch format

            Maxime Lemanissier added a comment -   url = "{}/admin/ rest /um/1/user?username={}&expand=attributes" .format(JIRA_BASE_URL, quote(user_name))   returns a json representation of the user, with extended details. createdDate attribute contains the user creation date in epoch format

            Kinda weird that this option doesn't exist. Please see this question for a real life situation where this might be needed.

            http://stackoverflow.com/questions/37176229/create-issue-validator-in-jira-that-would-prevent-spam-from-newly-registered-use/37184696#37184696

            Somaiah Kumbera added a comment - Kinda weird that this option doesn't exist. Please see this question for a real life situation where this might be needed. http://stackoverflow.com/questions/37176229/create-issue-validator-in-jira-that-would-prevent-spam-from-newly-registered-use/37184696#37184696

            Looks like there has been no activity in awhile, I am surprised to see this is still an issue. It would be nice to be able to query against account creation date. User accounts that were created 2 years ago and never utilized vs. a user account that was created yesterday and not yet utilized are two different things, it would be extremely helpful to be able to tell the difference for obvious reasons.

            Andrew Merriman added a comment - Looks like there has been no activity in awhile, I am surprised to see this is still an issue. It would be nice to be able to query against account creation date. User accounts that were created 2 years ago and never utilized vs. a user account that was created yesterday and not yet utilized are two different things, it would be extremely helpful to be able to tell the difference for obvious reasons.

            I would like to use Jira as a tool to support an helpdesk process, having as main ticket creation channel the emails sent by the user to a dedicated mailbox.

            Since many users are repeaters, I appreciate the feature in Jira that creates automatically a user account once a new user sends an email to the dedicated mailbox.

            Now the limit I see is that I don't find a way to manage these users, for example:
            -I would like to monitor the users created on a period of time (each day or each week) in order to do some basic user management like:
            -having some numbers
            -clean up the display name
            -manage user groups consequently
            -etc.

            therefore I hope this improvement will be implemented the soonest

            Damiano Migliori added a comment - I would like to use Jira as a tool to support an helpdesk process, having as main ticket creation channel the emails sent by the user to a dedicated mailbox. Since many users are repeaters, I appreciate the feature in Jira that creates automatically a user account once a new user sends an email to the dedicated mailbox. Now the limit I see is that I don't find a way to manage these users, for example: -I would like to monitor the users created on a period of time (each day or each week) in order to do some basic user management like: -having some numbers -clean up the display name -manage user groups consequently -etc. therefore I hope this improvement will be implemented the soonest

            JarkkoR added a comment -

            This was a big surprise that the date a account was created was not implemented from start in Jira. Should not be difficult to implement.

            JarkkoR added a comment - This was a big surprise that the date a account was created was not implemented from start in Jira. Should not be difficult to implement.

            Wow! The userbase table does not have a created_date.
            Of course it needs to be there (since version 0.1 ).

            Ovidiu Todoran added a comment - Wow! The userbase table does not have a created_date. Of course it needs to be there (since version 0.1 ).

            I'd love this option...

            Brian Esserlieu added a comment - I'd love this option...

            Simply add the following fields to the jira user table in the DB:

            • user creation date
            • user update date
            • user last login date

            Ludovic Lambert added a comment - Simply add the following fields to the jira user table in the DB: user creation date user update date user last login date

              Unassigned Unassigned
              4623d825f066 Ludovic Lambert
              Votes:
              78 Vote for this issue
              Watchers:
              47 Start watching this issue

                Created:
                Updated: