Report with users funcion

[Petru Negrusa]

Hello community,

We have ScriptRunner,Active Directory Sync,EazyBI.
Since all users are integrated from Active Directory, I need to create a report to understand what function a user who assigns a ticket has.
It would be best to do this through EazyBI dimensions so that I can select IT and see all users within IT by function or something similar.
If there are other possibilities through ScriptRunner, I am open to analysis.

P.S 

In the user profile, there is Active Directory sync where the user's function is displayed, but it cannot be filtered by that.

Thank you.

[Nauris Malitis -eazyBI- · Accepted solution]

Hi @Petru Negrusa 

Nauris from eazyBI support here.

This is a bit tricky since the Jira REST API endpoints won't return attributes synced from Active Directory.

There are a couple of ways to approach this:

1) Export a CSV file directly from the Active Directory containing names or usernames in one column (should match exactly as they are in Jira) and the "Function" in another column.

You can then upload this CSV file into the Source Data -> Source Files section and map it in the same manner as described in this eazyBI Community post.

2) You could get the same list of details directly from Jira by building a custom "REST Endpoint" that would return a list of usernames and functions when called. (Unfortunately, I don't have any examples that I could provide for this)

Then, in the Source Data tab, you can add a new REST API source and map it in the same manner as mentioned above.

 Let me know if you need assistance setting this up! You can also reach us at support@eazybi.com

P.S. Thanks @Piotr Witka for the ideas!

​Best regards,

​Nauris / eazyBI support

[Piotr Witka]

Hi @Petru Negrusa  You can try this app User Export  to get members of specific group exported in csv. Also you can use this Jira API endpoint to export users : 

Once you have your csv you can import it to Assets & use as EasyBI dimentions.