Deleting unused Dashboards

Rathna_oz8kqx

As an JIRA admin over a period of time, you will find out that there are dashboards / filters / filter subscriptions from users either who left the company or may have been setup by an contractor who does not have access to the system anymore which are scheduled and hogging resources in JIRA to slowdown. What would be a correct / cleaner approach of cleaning up someone else's crap.

Logan G Hawkes

I would suggest starting by generating a list of dashboards owned by each departed user, then constructing the URL to each dashboard manually. Some shared dashboards may be favorited by other users, so you may want to transfer ownership instead of deleting them. 

You can pull the list of dashboards out of the database with this query:

mysql (jira@JIRA_PRODUCTION:jiradb443)> select * from portalpage order by USERNAME;

The relevant URL format is: http://jira.initech.com/secure/Dashboard.jspa?selectPageId=$portalPage.ID

Caveat: it's probably safer to do this with a Groovy script or a REST/SOAP call instead of accessing the database directly.