We will list a few useful SQL queries that can help JIRA administrators quickly find the information they are looking for. It's important to mention that new versions of JIRA are released quite regularly, with new features and bug fixes. The database schema may change slightly in new versions. Therefore, verify your SQL queries on the new version of JIRA before using them.
The following SQL query will list the filters created in the JIRA instance that are shared with others:
SELECT sr.filtername, sr.authorname FROM searchrequest sr LEFT JOIN sharepermissions sp ON sp.entityid = sr.ID WHERE sp.entitytype = "SearchRequest" AND sp.sharetype != "global";
It's quite easy to find users of a specific group from the JIRA interface, but you should know how to fetch this information using SQL. The following query will list the users of the
jira-software-users group. You can change it to any group in your instance: