Exportable role permissions report

Apryl Harris_ud87de

Hello,

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.

Thank you,

Allan Maxwell

@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];