As a Jira Admin, I need a quick way to list all projects that are using the default priority scheme.

In the "Projects" column of the "Default priority scheme" we can only see: Global (all unconfigured projects).

This makes it difficult to determine what projects are using it.

Workaround

Use the following SQL query against the Jira database to list all projects that are not using a custom priority scheme, which indicates the default priority scheme is being used.

SELECT pname AS "Project"
FROM project
WHERE id NOT IN (SELECT project FROM configurationcontext WHERE customfield = 'priority' AND project IS NOT NULL)