Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

How to get list of unused screens in JIRA server

Please help us to provide DB query to get list of un-unsed screens in our JIRA server.
So that we clean up our server.

2 answers

0 votes

To delete screens safely in Jira, you need to go to Admin -> Issues -> Screens, find the one you want to delete, and click "delete" on the options menu to the right of it.

To identify screens that are not in use in Jira using SQL, you have to

  • construct a negative query (search for all screens, then subtract the ones you can identify as being in use), which needs to look at
    • screen schemes that may be using it (which then leads you on to whether the schemes are in use, and and and)
    • workflows (stored as XML which means you'll need to write something that can parse the XML for the screens in use)

Seriously, the most simple way to clean out your unused screens is to go to Admin -> Issues -> Screens and click "delete" next to each screen that has no entries in the screen schemes and workflows columns.

Before you do that though, I would recommend going to admin -> workflows, expanding the "unused" area and deleting as many as you can in there, and the same for "screen schemes" and "issue type screen schemes".

Sure, that's a bit manual, and a bit of a slog, but it's a lot easier than trying to report on it in SQL and then having to click through all the same stuff anyway.

We have more than 20000 screens in our server manually difficult to go through each and every screen to delete.
If we get list of un-used screens so that we can delete easily

A list is not going to make it any easier to delete them.

How would it help you when you do what I said in the first line of my answer?  The list of unused screens is in Admin -> Issues -> Screens already, and you can trigger the delete from there.

I mean you could scrape that screen and all its hundreds of pages, stick it into excel and filter for all the screens that have both "scheme" and "workflow" columns empty,  But to use that list, you're going to have to go to Admin -> Issues -> Screens, match an item and then click on delete.  You might as well just work directly off the list!

We cant install new plugins in our server and can you please suggest some alternatives.

Suggest an answer

Log in or Sign up to answer

Atlassian Community Events