Need your help to create the Servicnow alert details in SQL format.
which should contain the following data:
ServiceNow Ticket number, TimeStamp, Alert Name, Alert Message, Related node Caption, Last triggered Date, Severity, Acknowledged by, Vendor.
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
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.