Is it possible to report incidents, request, RITM, and tasks with caller/requester user account information

heidiyablonski
Tera Contributor

Hello community,

Our organization just began using ServiceNow a month ago and I have no prior experience with ServiceNow so please be patient with me.   I am being asked to produce a single report that will include all incidents, tasks, RITM's and requests (that was simple enough) that includes all user (caller or requester/requested for) information.   Is there a way I can report all that information in a single report?

Thanks,

Heidi

1 ACCEPTED SOLUTION

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hello Heidi,



You can report based on TASK table.


Screen Shot 2017-05-15 at 10.24.37 AM.png


Let me know if you have any questions.


View solution in original post

11 REPLIES 11

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hello Heidi,



You can report based on TASK table.


Screen Shot 2017-05-15 at 10.24.37 AM.png


Let me know if you have any questions.


Harsh Vardhan
Giga Patron

Hi Heidi,



yes select the table "task" in report.



Incidents/Tasks/Requests Received and Resolved By Assignment Group



Hope it will help you.



Thanks,


Harshvardhan


SanjivMeher
Kilo Patron
Kilo Patron

You can create a report on task table.



In the report use show related fields to display child tables and their corresponding fields in that tables and



For incident select Caller,


For Request, use Requested For


For Change, Requestor



etc.



Please mark this response as correct or helpful if it assisted you with your question.

nyancer3
Tera Expert

Hello Heidi,



You can "dot-walk" to the fields in the user table. Here is a good section in the docs that explains it: Dot-walking in list collectors.



For example, you would start from the "Caller" field, then dot-walk to the fields on the caller table that you want to include.



Hope you find that helpful.



Thanks,


Nicholas.