Reports - Notify_Call

[ratnasekhar]

Hello All,

I am trying to create a Report from Notify Call which has all below fields.

Is there a way we can create a report that contains the call made for the incident along with the IIncident #, Priority, Short Description , Assignment Group , Date Created and Category on the incident table.

Phone number

Client

Direction

Parent call

Source

Active

Created

Calculated Name

Call ID

Client table

Country

Created by

Is human

Last action

Notify number

Source table

Tags

Type

Updated

Updated by

Updates

XXXXXXX

Outbound

Incident: INCXXXXX

FALSE

04/03/2025 00:27:05

XXXXXXX

CXXXXXXXXX8

XXXXXX

system

FALSE

{"fClassName":"NotifyAction","fActions":[{"type":"SayAction","properties":{"fClassName":"SayAction","fLanguage":"en-US","fText":"You will now be disconnected. Good bye.","fExtraOptions":{}}}]}

Twilio Notify (+XXXXXXX)

incident

Phone

XXXXXXX

guest

5

Regards

Ratna

[J Siva]

Hi @ratnasekhar 

Yes.. you can.

For that you need to first create a data base view by joining Notify call and incident table.

You can match the source id field from Notify call table with sys_id field of incident table.

Then build a new report on the database view. Let me know if you need more information.

[ratnasekhar]

Thank you Supriya. The Solution worked!!

[SupriyaWaghmode · Accepted solution]

Hello Ratnasekhar ,

When data is not centralized in a single table, creating a database view becomes crucial to accurately reflect information in the report. This practice enables joint table actions, streamlining the overall process. Here's a step-by-step guide to follow:

1. Create a database view.

2. Integrate a table into the database view.

3. Specify the fields to be returned.

4. Determine the appropriate left join/right join on tables.

5. Rename columns for clarity.

6. Define the desired number of records to be returned.

7. Validate the database view through testing.

By diligently executing these steps, you can efficiently organize and access the necessary data for your report, ensuring precision and effectiveness in your analysis.

You will get many article and knowledge content for report creation from database view. Please this as well if  your use case matches. 

Thanks & Regards ,

Supriya Waghmode |ServiceNow Consultant

www.linkedin.com/in/supriya-waghmode