Hi Guys,
I am trying to create a Custom SQL Alert, however, it gives me false alert.
Would like to ask, is there a way to remove this? Or any other way around not to use the Set your SQL condition? Thank you
there is no way to remove this...each alert has to be "anchored" to an object [type] in Orion, i.e. node (in this case), volume, component check, etc...
you can do joins in the below section to get info/criteria from other tables like custom property tables, etc...
perhaps a little more info on what you are specifically trying to accomplish?
There is no trigger condition, your query as it stands now it merely polling NodeID, and Caption from the Nodes table. This would work more for a generic report query than an alert. What are you trying to alert on? I may be able to point you in the right direction if I knew what the alert was suppose to trigger on. You may want to try the drop down triggers rather than setting the alert up with a SQL statement.
Thanks njoylif, I was able to resolve my issue