I just need last 7 days alert history with service-now associated ticket number .
Kindly help on the same
Hi Axg4437,
I cant test this script as I don't have any service now incident numbers. However, it should give you what you are looking for, or at least point you in the right direction.
SELECTToLocal(s.LastTriggerTime) AS [Date],s.IncidentNumber AS [Ticket#],o.RelatedNodeCaption,s.State,s.AssignedTo,s.Description,s.IncidentUrlFROM Orion.ServiceNow.AlertIncident sJOIN Orion.AlertObjects o ON o.AlertObjectID = s.AlertObjectIDJOIN Orion.Nodes n ON n.NodeID = o.RelatedNodeIdWhere Daydiff(o.AlertActive.TriggeredDateTime,GETUTCDATE()) > 7
terryk : thanks for your update it is working
Am using the below query but unable to do the filter for last 7 days ...do you have any idea to insert last 7 days data to display
SELECT LastTriggerTime as TimeStamp, IncidentNumber as ServiceNowTicketNumber, I.AlertObjects.AlertConfigurations.Name as AlertName,I.AlertObjects.AlertActive.TriggeredMessage as AlertMessage,I.AlertObjects.RelatedNodeCaption,I.AlertObjects.AlertConfigurations.Severity as Severity,I.AlertObjects.AlertActive.AcknowledgedBy,I.AlertObjects.Node.VendorFROM Orion.ServiceNow.AlertIncident as I
Axg4437, Try the following.