Service Now Incident information in Orion DB

Question

Hi Guys,

I am finding out the table in Orion database which stores the service now incident number information ? I could not find it in AlertHistory logs.

Anyone knows, please help.

Thanks.

SNOWINC.JPG

alankar.srivastava · Answer

Thanks rmullal.

rmullal · Answer

SNI_AlertIncidents is the table you're looking for.

I use this query to grab the incident number:

SELECT IncidentNumber FROM [dbo].[SNI_AlertIncidents] WHERE AlertObjectID = ${N=Alerting;M=AlertObjectID} ORDER BY IncidentNumber DESC

And this one to grab the URL:

SELECT IncidentUrl FROM [dbo].[SNI_AlertIncidents] WHERE AlertObjectID = ${N=Alerting;M=AlertObjectID} ORDER BY IncidentNumber DESC

Hope this helps!