Report on all tickets for a specific user

ChandanaRodrigo
Giga Contributor

I'm looking to generate a consolidated report in ServiceNow that includes all tickets related to a specific user. Specifically, I need to capture: Contact Tickets, Incidents, Requests

Since these tickets are stored in different tables, it's challenging to pull everything into one single report. My current approach is to create separate reports for each type of ticket and place them in a dashboard.

However, I'm facing the following challenge:
When placing these multiple reports in the dashboard, how can I dynamically pass the user details (e.g., user's name or id) to all the reports at once? I want to avoid manually entering the same user information for each report individually.

Any tips or best practices for handling this scenario would be greatly appreciated.

1 ACCEPTED SOLUTION

Mark Manders
Mega Patron

Create an interactive filter on your dashboard with the user(s) to select. You can add where to look for on which table (like caller on incident and contact on case). If it's all shared field(s) (like opened by), you can just put the filter on that. In that case, you can also just create the report on task level, look for the 'opened by' and just filter on the task types.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

7 REPLIES 7

ChandanaRodrigo
Giga Contributor

@Mark Manders please ignore my last request. I think I found what I was looking for. Thank you very much for your advice. This has helped me a lot.

Suzanne H
Tera Guru

Hi @ChandanaRodrigo 

go to Reports > View/Run, then search for it by name

SuzanneH_0-1726594054611.png

SuzanneH_1-1726594070909.png

you could make a copy of it and modify it as needed, but it's close to what you want

Thank you Suzanne