SQL Query Users Added to Jira

[Jeffrey Howard]

I am looking for a SQL Query that will show the date a user was added to Jira?

Thanks...Jeffrey...

[Vamsi Kandala · Accepted solution]

Hi @Jeffrey Howard

Welcome to the community!

If you have access to the database, you can lookup the 'cwd_user' table where the user details are specified.

Hope this helps.

Thanks,
Vamsi

[Jeffrey Howard]

YES, but not sure how to find the date the were added to Jira

[Vamsi Kandala]

Hi @Jeffrey Howard

The 'created_date' column gives the date when the user is added to Jira.

You can use the 'user_name' or 'email_address' column to search for a particular user.

Hope this helps.

Thanks,
Vamsi