Possible to see user creation date/time.

Simon Karberg April 9, 2014

Hi.

Is it possible to see when a user is created in Jira?

1 answer

1 accepted

2 votes
Answer accepted
Andris Grinbergs
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 9, 2014

You should look in CWD_USER table column CREATE_DATE.

Andris Grinbergs
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 9, 2014

I think it's not. Couldn't find it.

Simon Karberg April 9, 2014

Isn't it possible to see by the web interface?

Mani April 12, 2018

@Simon Karberg3 

The below PSQL should help you with what you are looking for.

 SELECT user_name, created_date, first_name, last_name, email_address FROM CWD_USER order by created_date desc;

Like Vijay Koleti likes this
Vijay Koleti March 28, 2019

Thanks.. worked like charm..

Kristin Fast February 7, 2020

I am trying to find this. I am not a developer or coder, so could you point me to WHERE to go to do this? Sorry, and thank you

Suggest an answer

Log in or Sign up to answer