need mysql querys for my jira clean up activity

Mahendar_45vewy

Hi team, we 300 projects in jira we wants to migrate new version present v7.11 but we have lots of inactive issue type scheme, fields scheme, workflow scheme, permission scheme,notification schemes so i do not want these please share me the mysql querys Asap

LarryBrock

Hi @Mahendar !  Not sure what your policy is for using and testing add-ons but where I'm working now, we've found tremendous value in the Cleaner for Jira add-on.  It handles the heavy-lifting of identifying unused items and can then remove them with the click of a button. Cheers!