- 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 09:51 AM - edited 05-26-2024 09:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 10:28 AM
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:
And in the Incidents table I cannot find any column to bring the outage number.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 10:35 AM
Apologies. I misunderstood the question. Did you check the m2m tables. Check the related list.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-26-2024 10:40 AM
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...