SQL Query Users Added to Jira

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

Thanks...Jeffrey...

1 answer

0 votes

Answer accepted

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.