Reporting between Appointment, Interaction and Incident tables

[Kenny Mitchell]

Hello,

Attempting to find a way to adequately report between the wu_appointment, interaction (and/or interaction_related_record), and incident tables. 

If I create a report from the wu_apointment table, I can obtain WUA and IMS numbers, but cannot figure out how to add associated INCs to columns or filter conditions.

The only way I can find related INC numbers is to create a report from the interaction_related_record table. If I do this, I can pull the IMS number as well as the "Task", which shows me the INC. However in this method I have no way to pull the WUA.

Basically... looking for some way to reach an INC from a WUA that are linked by a common IMS and create criteria/columns around these links.

Thanks,

Kenny

[Muralidharan BS]

Hi Kenny,

The related list from the Interaction record is a scripted related list. So this cannot be achieved directly instead you have to use a database view to attach all three together. 

how to create database view - https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/use/reporting/task/t_CreateADatabaseView.html

Thanks,