Filling Out SolarWinds ServiceNOW Alert Trigger Action Field With SWQL Query

Matthew.Frias

This is my first post, so I hope I am doing this right and I am in the right place, haha, but...

I am working with a customer where they wish to have their Assignment Group field populate with a default value if the Custom Property we created for this isn't configured for the device. Currently my SWQL query is as follows:

${SWQL: SELECT 
CASE When n.customproperties.SNOW_AssignmentGroup is null Then '[Assignment Group Default They Provided Here]'
ELSE n.customproperties.SNOW_AssignmentGroup
End as CP
FROM Orion.Nodes N
Where N.NodeID =${N=SwisEntity;M=NodeID}}

I have validated the query in their system outside of the "${SWQL:}" wrapper and "Where N.NodeID =${N=SwisEntity;M=NodeID}", and only have that applied on the query in the field I am putting it in. 

When testing this, the Assignment Group isn't coming into their SNOW as the expected behavior. I am not sure what I may be missing here, so any and all help would be greatly appreciated!

Matthew.Frias

I figured it out. My wrapper was incorrect. Where I had "${SWQL:" it should have been "${N=SWQL;M=SELECT" instead. Once I corrected the wrapper, it works as expected when I simulate it.