Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Database query for user's history

We are in the process of merging two Jira instances together.  The instances have different user bases.  We would like to find a database query that will list all of the active users who have data associated with their account (issues assigned to them, issues they created, issues they are the reporter on, issues they commented on, etc).  Is there any way to do this?

My use case: We want to create users in the the final Jira instance only if they are currently active in the other Jira instance and only if they have data associated with their account.  In order to do this we need to compile a list of those users.  We are limited by our Jira software server license tier at this point and are not planning on migrating environments until next year.

I have come up with the following queries below but I'm not sure how I can consolidate them and also a way to get any other information that we might need (such as the comments).

I know I can query:

select * from cwd_user where active = 1;

select creator from jiraissue order by creator;

select reporter from jiraissue order by reporter;

select assignee from jiraissue order by assignee;

 

1 answer

1 accepted

0 votes
Answer accepted

You'll need to read a lot more tables than those.   Comments, issue history, (multi-)user pickers, and and and.

A far more simple solution - go to the list of users and deactivate any user who has not logged in within a reasonable length of time.   That way you won't lose data or have to migrate it all when you drop them during migration, but they won't count towards your licence limits.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.13.2
TAGS
Community showcase
Published in Jira Service Management

JSM June Challenge #2: Share how your business teams became ITSM rockstars

For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...

172 views 6 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you