Hi,
I've been running Jira for over 6 years -- and I have a tons of projects, issues, custom fields, plugins, etc.
I am looking for any tips on cleaning up my instance. I know how to find old issues. But what I am looking for is:
1. Projects that haven't been used since a certain amount of time
2. custom fields that aren't being used (either associated with a project, or associated with an issue)
3. Email handlers that aren't being used
4. Listeners that aren't being used
5. Services that aren't being used
6. General DB clean-up tips -- for example, my instance has over 12 million lines in the notificationinstance table!
As for removing issues in bulk, or notificationinstance -- I usually just delete stuff via sql query, then run an integrity check to fix any fallout -- not ideal (and this has only been done in test instances).
I have 180,000 issues or so spread across 100+ projects. Nightmare. :)
Any tips appreciated!
Regarding unused projects, you could search for issues for created date or updated date for the past several weeks or months. I think custom fields can be search via Issue Navigator as well.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.