Where can I find a column related to Outage in Incident Table

Marco3007
Tera Contributor

Hi!

 

Hopefully it's a simple question... so, from Outage table (in my instance it is named [cmdb_ci_outage]) I can find "Task Number", which points to the related incident record number. So I believe there must (could?) be a relationship to Outage records in one of the available columns in the Incident table (which for me is [incident]), but I can't find none...

 

Below is what I have. I have digged into the dot walk columns as well, but could not identify if any would turn out to be what I need -- Outages.

 

Any advice?

 

2024-05-26_13-18-10.png

1 ACCEPTED SOLUTION

task_outage table. Many-to-many (M2M) relationships are similar to one-to-many relationships, except that they aren't usually dependent on a foreign key column in a child table. Instead, many-to-many relationships in ServiceNow usually rely on an intermediary table called an M2M table.

View solution in original post

8 REPLIES 8

Hi,

OOB there is no direct reference to Outage from the Incident table, but as @Pratiksha mentioned, you can find Outages through related lists.

Select Configure > Related Lists
Then you can add "Outage -> Task number"

task_outage table. Many-to-many (M2M) relationships are similar to one-to-many relationships, except that they aren't usually dependent on a foreign key column in a child table. Instead, many-to-many relationships in ServiceNow usually rely on an intermediary table called an M2M table.

Marco3007
Tera Contributor

Thank you @Pratiksha  and @OlaN, I will look into it further.

Please mark the answer correct if it helped. 

 

Regards,

Pratiksha