Hi @AnneMarie Gaspari, I've done this before by querying the database. Here are some sample MySQL queries to get you started. Work with your DBA to optimize them or customize them for your DB type/version.
Users per Role per Project
Use: Gauge the impact of deleting or renaming a role. Understand role popularity. Spot old permissions for users who've left the company.
Sample Query: SELECT project.pkey, projectrole.name AS "role", roletypeparameter AS
"user" FROM project, projectrole, projectroleactor WHERE
project.id = projectroleactor.pid AND
projectroleactor.projectroleid = projectrole.id AND
roletype = 'atlassian-user-role-actor' ORDER BY pkey, role ASC
Additionally, the Admin UI will tell you individual role membership. Visit: Admin > System > Project roles and then drill down from there.
Users in Groups
Use: View the list of users per group.
Sample Query: SELECT parent_name AS "group", child_name AS "user" FROM
cwd_membership ORDER BY parent_name, child_name ASC
Of course, you can also view individual group membership from: Admin > User management > Groups.
There's probably a helper app (add-on, plugin) that might do it for you or you can get to the data through the API.
Hope this helps get to some or all of what you're after! I do wish there was one easy report. ;)
Rachel Wright
Author, Jira Strategy Admin Workbook
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.