Help to create the Servicenow alert report in sql format.

[er.vansh17091]

Hi All,

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.

[LadaVarga]

Hello,

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

Lada

[Prineel]

Thanks for this, its very helpful!

Is there anyway to change the time frames?

[er.vansh17091]

Thank you! Its working for me.