nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Query Users Added to Jira

Jeffrey Howard_sz9lqa

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

Thanks...Jeffrey...

Accepted answers

Vamsi Kandala

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

All comments

Vamsi Kandala

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_sz9lqa

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server