Mapping User Accounts to Projects

[Marc Hartman]

We just recently upgraded to the Enterprise license tier and are trying to use Atlassian Analytics to map users from the Admin user module to their respective project in Jira.  We use an SSO tool to grant licenses and assign everyone the jira-software-users group to everyone aside from a few Administrators.  How can I use Atlassian Analytics to show which project a user has been assigned to as well as those who are not assigned to a project?

[Robert]

Hi @Marc Hartman ! 

Currently, the Atlassian Data Lake does not include a table that maps users to their Jira project/space roles or permissions. That said, we do have a feature request open to track interest for this down the road.

• https://jira.atlassian.com/browse/ANALYTICS-65

There is a workaround mentioned there that uses the Jira API to bridge this gap as well - though that is probably better suited for one-off ad-hoc analysis rather than ongoing reporting needs. Another proxy for this might be to query Jira tables for activity in projects by user, but that is not quite exact either.

Hope this helps!