How to get a list of users using Charting plugin in JIRA 7.13?

[Divya TV]

We have a requirement to disable jira charting plugin on jira datacenter 7.13. Need to notify the active users. Do you have a SQL query that can be executed against the database to get the list of users?

[Divya TV · Accepted solution]

Figured it out. The tables portletconfiguration and portalpage have what you need.

[Anil Kumar A]

hi.. could you please share the SQL queries to find list of users.. thanks

[Craig Castle-Mead]

In preparation for Jira 8.20 > 9.12 LTS (testing on 9.11), I've prepared the below (tested in psql) - hopefully it helps you somewhat

SELECT
  w.gadget_xml,
  CASE WHEN u.active = '1' THEN
    true
  ELSE
    false
  END as user_active,
  count(*)
FROM 
  portletconfiguration AS w,
  portalpage AS d,
  app_user AS au,
  cwd_user AS u
WHERE 
  w.portalpage = d.id AND 
  au.user_key = d.username AND
  au.lower_user_name = u.lower_user_name AND 
  w.gadget_xml LIKE '%com.atlassian.jira.ext.charting%'
GROUP BY 1,2
ORDER BY 1,2
;

CCM