Filter owner details for inactive user

Question

Hello All,

I'm struck with an issue, where one of the user ID has been set to inactive in AD which means his user details are in active in Jira because AD is synced with Jira.

Here I would like to find the list of Dashboard names and filter details of the user, Unfortunately we do not have filter names or Dashboard names . Is there a way to find the details through SQL?

Thanks in advance

Deepak

Benjamin_tmh9yg · Answer

HI @Deepak ,

You can search it by owner as mention by the post. That should be a lot less than 7K.

https://confluence.atlassian.com/adminjiraserver/managing-filters-938847876.html

-Ben

Deepak_2r8eib · Answer

Hi @Benjamin  Thanks for the suggestion. We have more then 7k filters, this may take lot of time to search one by one. Unfortunately,  I do not have filter names to change the owner through UI.

Benjamin_tmh9yg · Answer

HI @Deepak ,

SQL may not be straight forward as you will probably need to join a number of tables.

However, you can access this information in the UI. Read this post:

https://community.atlassian.com/t5/Jira-Service-Management/Filter-Owner/qaq-p/1921296

Thanks,

Ben