Add Date column in ServiceNow Incident Widget

rmullal

We use the following ServiceNow widget for several node views:

It would be helpful if we could add the LastTriggerTime column to the out of the box widget.

However, I am having trouble passing in the NodeID variable.

This is the query i came up with:

SELECT e.EntityCaption, a.IncidentNumber, a.LastTriggerTime, a.State, a.Assignee, a.AssignmentGroup, a.Description
from Orion.ServiceNow.AlertIncident a
join Orion.AlertObjects e on a.AlertObjectID = e.AlertObjectID
join Orion.Nodes o on o.Caption = e.EntityCaption
WHERE e.EntityCaption = ${NodeID}

order by LastTriggerTime desc

I just get an "error processing request" when i throw that query in the custom query widget.

Any help would be greatly appreciated. Thank you. 

rmullal

figured it out! this is what i was after:

SELECT e.EntityCaption, a.IncidentNumber, a.LastTriggerTime, a.State, a.Assignee, a.AssignmentGroup, a.Description
from Orion.ServiceNow.AlertIncident a
join Orion.AlertObjects e on a.AlertObjectID = e.AlertObjectID
join Orion.Nodes o on o.Caption = e.EntityCaption
WHERE o.NodeID = ${NodeID}

order by LastTriggerTime desc