Create a report based on (custom) user details

Question

Hello all,

I am trying to create a report in Jira Service Desk - based on user details.

We have pulled in extra details with the user from our IDP (identity provider like Okta) - things such as:

* Business Unit
* Location
* etc...

We would like to build a report based on these details - so, for example:

Tickets created by location, or tickets created by business unit.

Is this possible?  To pull these into JQL to build a report from?

Thank you.

Scott Hallett · Answer

Thank you Asmath!  I have tried using JQL - but I did not know what fields to supply.

The auto-suggestion fields did not show up.

Example:

We have a field called "Department" that is part of each of the managed user accounts

But not sure how to pull this into a query:

(or something similar .. basically trying to create a report of tickets created by "department")

Thank you!

Asmath Basha S · Answer

Hi @Scott Hallett

* By using JQL Query you should filter the tickets based on the conditions which you want.
* Then add the fields in the Columns which you want to display in the report.
* Then by using the Export option from the Top Right Corner you can pull the reports in Excel or CSV file.

Regards,

Asmath Basha