- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 09:20 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 10:50 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 10:46 AM
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 10:50 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 10:50 AM
Thank you @Pratiksha and @OlaN, I will look into it further.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 10:51 AM
Please mark the answer correct if it helped.
Regards,
Pratiksha