How to find a count of Jira System Admins and Jira Configuration Admins in MySQL database

[Judah]

I am using Microsoft SQL Server Management Studio to query my JIRA db.

I want to pull out the number Jira System Admins and Jira Configuration Admins. 

Any advice on what that query would look like? 

[Nic Brough -Adaptavist-]

Quite ugly, as you'll need to look in the settings to work out which groups have admin rights, then the group table to work out which ids are in the groups, then the user table to find out who they are.

It is easier to have a look at the global permissions, noting which groups have admin, then look at each group in user management.

[Craig Castle-Mead]

Hi Judeb0y,

Any reason why you need SQL over the global permissions page available at https://jira.example.org/secure/admin/GlobalPermissions!default.jspa ?

CCM

[Judah]

@Craig Castle-Mead

Thank you for your response. 

Once a month I report certain statistics regarding Jira into a separate monitoring application (tableau). Currently, I am able find these statistics in the admin section of the GUI, which I report manually. 

My problem has arisen from the fact that I am trying to automate the dispersal of these stats into tableau, via SSIS. 

I am using Microsoft SQL Server Management Studio to query the database which houses my Jira data but I am unable to find some of my stats. I assumed that if I can see these stats in the GUI, they must be housed in the db somewhere. If that is not the case, I will have to pursue other options.

I am not sure how to leverage the global permissions page in this same manner. The link you provided appeared broken to me.