1 of 1 people found this helpful
We don't have SQL but I can give you SWQL query as it is more easier.
If you want to tune it up, Please donwload Orion SDK and use SWQL studio for that. It has intelisense and you can get whatever you want via Navigation property.
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.Vendor FROM Orion.ServiceNow.AlertIncident as I
Thank you! Its working for me.