Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Help to create the Servicenow alert report in sql format.

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.

Find more posts tagged with

Accepted answers

All comments

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

er.vansh17091

Thank you! Its working for me.

Prineel

Thanks for this, its very helpful!

Is there anyway to change the time frames?