Yep it's a database query in plain Jira.
There are some apps that enable you to extract it though - migration and housekeeping tools tend to do it (Project configurator, Configuration manager, etc), and you can use the scripting apps to run scripts to report on it too.
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