We are currently working on Solarwinds integration with ServiceNow using OOB pull connector.
By logic (my understanding), Servicenow connector pull events
EventID, EventTime, NetworkNode, NetObjectID, EventType, Message, Acknowledged"
And Event Types table,,Severity value of Incident is defined based on Icon Values
EventType, Name, Icon, NotifyMessage,NotifySubject
But when it comes to custom alerts,, the event type will be mostly 5000, for which serverity cannot be mapped from Event types..
Any pointers available here,
" Alert severity should be pulled by ServiceNow".
As per schema documentation ,Orion.AlertTriggered, shoul have all active alerts, but couldn't see any values on them
u can try to use the severity variable in the alert body and then try to parse on ServiceNow side..
we are going to try that sometime this week or next.. i will let u know if that works...
we did the test of using severity variable in the alert message and then on ServiceNow the SME was able to put up the rule and make it work...
So critical comes as critical and warning and warning....
@mesverrum, Thanks for the right directions.
I am thinking to interjoin below three Orion tables here to achieve my objective , but need help to concat the values
1. Orion.Events as [EV]
2. Orion.AlertObjects as [AO]
-> Connecting attribure [AO].EntityNetObjectId = concat ('[EV].NetObjectType'':''[EV].NetObjectID')
Sample-> EntityNetObjectId like AM:792
3.Orion.AlertConfigurations as [AC]
-> Connecting attribure [AC].AlertID = [AO].AlertID
Could you please, help how to concat values for [AO].EntityNetObjectId as mentioned above
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. Learn more today by joining now.