Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Create a report based on (custom) user details

Scott Hallett
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 3, 2024

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.

1 answer

0 votes
Asmath Basha S
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 5, 2024

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

Scott Hallett
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 7, 2024

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

Screenshot 2024-05-07 at 3.04.36 PM.png

 

But not sure how to pull this into a query:

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

 

Screenshot 2024-05-07 at 3.07.33 PM.png

 

Thank you!

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events