How to get list of unused screens in JIRA server

[pradeep km]

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.

[Nic Brough -Adaptavist-]

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.

[pradeep km]

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

[Nic Brough -Adaptavist-]

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!

[Pedram Mireftekhari]

Database manipulation is not suggested in Jira, but if you have Scriprunner you can run these scripts suggested here:

https://confluence.atlassian.com/clean/advanced-cleanup-1018789335.html

or here

https://community.atlassian.com/t5/Jira-questions/How-can-we-find-the-unused-workflow-workflow-schemes-and-screens/qaq-p/602116

[pradeep km]

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