You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have requested this previously and learned it is not available via export in Jira Align or via API.
I would like an Atlassian representative to submit an official ticket to have exportable role based permissions reporting created (i.e. what permissions are toggled on/off per role). A role side by side view per module would be extremely helpful.
Once the official ticket is submitted, can the link to it be placed here so we can vote on it.
@Apryl Harris Do you have Enterprise Insights or Atlassian Analytics? If so, you could do something like this:
SELECT Role.[Role ID], Role.[Role Name], Permission.[Permission Level], Permission.[Permission Name]
FROM [current_dw].[Role] AS Role
LEFT JOIN [current_dw].[MAP Role to Role Permission] AS RP_Map ON RP_Map.[FK Role ID] = Role.[Role ID]
LEFT JOIN [current_dw].[Role Permission] AS Permission ON Permission.[Permission ID] = RP_Map.[FK Permission ID]
ORDER BY Role.[Role Name], Permission.[Permission Level], Permission.[Sort Order];