JQL User Profile Attributes

[Dustin Alcock]

We're currently syncing user attributes from Azure AD to user's Atlassian profiles. The next step to make this useful is to be able to use JQL to setup automation based on AD listed manager and reporter location.

While the data syncs to Atlassian, I'm not seeing a way to do anything with it, besides see some of the information in the user's profile.

Example: We sync department, how do I filter all tickets reported by those where department = department_name?

Also, mapping allows the ability to sync "urn:ietf:params:scim:schemas:extension:enterprise:2.0:User.organization", but I don't see where that's being written to in Atlassian.  What I'd do with this is sync the Office location to Organization, to allow us to route tickets based on "organization" (location) to techs in that office.

[Katarzyna Szumilas_Deviniti_]

Hi @Dustin Alcock

So far I'm aware this use case can be only achieved by using 3rd party addons. One of them is Azure AD Attributes for Jira developed by my team.
How this app can answer your requirements?

With Azure AD Attributes you can easly copy attributes of reporter/ assignee or user from user picker field to custom fields of the following types:

• Text Field (multi-line)
• Text Field (single-line)
• Text Field (read-only)
• User Picker (single user)

Once you map the user manager and location, you can build an Automation rule to assign tickets to the right development teams.
This same goes for the location (office) info.

You can also map the department attribute to any text field added to an issue and use it in the JQL query to filter out all the tickets raised by a specific team.

If that sounds interesting - feel free to try the app or book a free demo session. We will be happy to assist!

Best regards,
Kasia from Deviniti

[Eduardo Oliveira - Mindpro Apps]

Hello @Dustin Alcock - nice to meet you 👋🏻

If you’re open to use a third-party app I would like to recommend a powerful and cost-effective solution - Mindpro Sync - User Attributes from OKTA, Azure & OneLogin

This app allows you to integrate with identity providers like Okta, Azure AD, and OneLogin to display user attributes (such as reporter Location) inside Jira and JSM issues (and Portal) and use these attributes data to create JQL queries, filters, dashboards, create JSM queues, use in advanced automations, and more.

Additionally you can:

• You can choose to display data for the issue Reporter, Assignee or any other User field
• Select and map the user attributes to be displayed in Jira issues or JSM requests
• Show user hierarchy in issue panel and JSM requests to facilitate escalation and approvals
• Automatically assign approvers based on user hierarchy or via workflow post function.
• And more!

This app has a 30-day free trial version with full support and onboarding assistance included. If you want, we'd love to offer you a live demo where you can talk about your specific needs.

Hope it helps,
Eduardo, from Mindpro team