nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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?

Accepted answers

Divya TV

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

All comments

Divya TV

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

Anil Kumar A_4hk16x

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

Craig Castle-Mead_20fp9z

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

chart