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

To add, Administrators can configure a property that controls whether or not fields on extended tables can be added to base table lists. For example, you can view and filter on the caller_id field from the Incident table on a Task table list, such as the My Work list. Enabling this property does not show the extended table fields in the personalize list.



Please check section 2.1.1 for more info here.


http://wiki.servicenow.com/index.php?title=Configuring_Lists#Adding_Extended_Fields_to_Base_Table_Li...


Excellent point!


report.png



Hope it will help you and solve your requirement.


h_ctort
Giga Contributor

Hi, you can report from the task table and use a filter of requested for is 'user_you_need' and dot-walk to the user fields like in the picture below.


find_real_file.png


heidiyablonski
Tera Contributor

My struggle is the dot walking to the requested for user account details.   I think I've dot walked just about every way I can but I'm unable to find the "right" location..



I can dot walk to a RITM and from there I have other levels of RITM, some that include Request from the Request table.I've attached a screen shot of where I am dot walking to the Request for.cost center, but when I run the report, there is no data. I've tried several different locations, some from the RITM, some from RITM,RITM then requested for user account information 9in the example in the screenshot, it's the requested for's cost center)RequestedForInfo.png