How to find Jira Projects not assigned to a Issue Level Security Scheme

I am trying to locate all projects that are not using any sort of defined Issue Security Scheme? Is this possible using JQL or must this be a DB query?

1 answer

0 votes
Arthur Gonçalves
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
May 22, 2015

Hey there,

You can run the following query on JIRA DB:

select pname from project
where pname not in 
(
select pj.pname from nodeassociation na
inner join issuesecurityscheme iss on iss.id = na.sink_node_id
inner join project pj on pj.id = na.source_node_id
and na.source_node_entity = 'Project'
where na.sink_node_entity = 'IssueSecurityScheme'
);

-- Arthur Gonçalves

Suggest an answer

Log in or Sign up to answer