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

Pratiksha
Mega Sage
Mega Sage

Right click on incident form, you should see create outage option. It will create entry in cmdb_ci_outage table. 

Sorry, but that has nothing to do with what I asked... let me try to be clearer:

 

I know how to create outages based on incidents. I have created thousands. I am working on a report related to incidents and in it I would like to list the outages. Just like we have "Assigned to", "Created", "Resolution notes", I wonder if there is a column that lists the outage number.

 

The other way around is easy, in Outage table I can find "Task Number", which is the related incident. But in Incident table (observing I'm building a report, so it's in the REPORTS area, not INCIDENT FORM) I cannot find any column that related to outages (the previsous screenshot has the whole list, but below I'm adding another one to examplify it better).

 

Outage table > Task number column brings the incident:

 

2024-05-26_14-21-57.png

 

And in the Incidents table I cannot find any column to bring the outage number.

Apologies. I misunderstood the question. Did you check the m2m tables. Check the related list.

Marco3007
Tera Contributor

No problem, Pratiksha! Thank you for trying to help! 😃
Sorry for the ignorance, what are m2m tables? I don't know if I have access to these...