The field is already in the database

mysql> desc cwd_user;
+---------------------+---------------+------+-----+---------+-------+
| Field               | Type          | Null | Key | Default | Extra |
+---------------------+---------------+------+-----+---------+-------+
| ID                  | decimal(18,0) | NO   | PRI | NULL    |       |
| directory_id        | decimal(18,0) | YES  |     | NULL    |       |
| user_name           | varchar(255)  | YES  |     | NULL    |       |
| lower_user_name     | varchar(255)  | YES  | MUL | NULL    |       |
| active              | decimal(9,0)  | YES  |     | NULL    |       |
| created_date        | datetime      | YES  |     | NULL    |       |
| updated_date        | datetime      | YES  |     | NULL    |       |
| first_name          | varchar(255)  | YES  |     | NULL    |       |
| lower_first_name    | varchar(255)  | YES  | MUL | NULL    |       |
| last_name           | varchar(255)  | YES  |     | NULL    |       |
| lower_last_name     | varchar(255)  | YES  | MUL | NULL    |       |
| display_name        | varchar(255)  | YES  |     | NULL    |       |
| lower_display_name  | varchar(255)  | YES  | MUL | NULL    |       |
| email_address       | varchar(255)  | YES  |     | NULL    |       |
| lower_email_address | varchar(255)  | YES  | MUL | NULL    |       |
| CREDENTIAL          | varchar(255)  | YES  |     | NULL    |       |
| deleted_externally  | decimal(9,0)  | YES  |     | NULL    |       |
| EXTERNAL_ID         | varchar(255)  | YES  | MUL | NULL    |       |
+---------------------+---------------+------+-----+---------+-------+
18 rows in set (0.01 sec)

Hi,

The creation date of user account is essential and easy to implement, I think it can be implemented by adding a column field in DB for that. Then we can use REST API or GUI to know the creation date and then we also can sort the users by creation date to find out the latest created user account.

https://www.linkedin.com/pulse/long-term-jira-metrics-matt-doar/ may be useful if you have DB access

Hi,

While the DB queries are good suggestions, if one doesn't want to use the live production DB a REST API would be perfect.
I tried the suggestion provided by Maxime Lemanissier as shown bellow, however it doesn't seem to work

https://<localhost>/admin/rest/um/1/user?username=sxuvmp&expand=attributes

REALLY? 12 years is not enough for just adding `created_at` field? 

Hi All,

Created date is available in datable user table

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

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