I am attempting to write a SWQL query for a widget that contains the Incident Number and Caption that is associated with that incident number. I also only want it to display these results for nodes that are in a DOWN state.
I can't find anything in common between Orion.ServiceNow.AlertIncident and Orion.Nodes.
Ideally, this is what i'm going for:
Caption | IncidentNumber | AssignedTo | Description |
---|---|---|---|
I just can't find a table to join these on. Orion.ServiceNow.AlertIncident has DisplayName, but all the values are null.
Any help would be greatly appreciated. Thank you.