I wish to get the result of SWQL query into a variable for creating an alarm.
Sample query:
SELECT ReceiveBps
FROM Cortex.Orion.Interface
WHERE InterfaceID = '12562';
Kindly help.
How to get result of SWQL query into variable for alert processing
-
I would just write the whole alert in SWQL. You need to use the supplied Select Statement but you can usually get what you need by using the URI or by joining additional tables.
-
Hi,
I am trying to do some calculation using this query
SELECT ReceiveBps as rbps, MaxInBpsToday as maxbps
FROM Orion.NPM.Interfaces
WHERE InterfaceID = '12562';where two variables - rbps , maxbps are to be use to quage the condition.
Unfortunately, I am not able to do this.
The query cannot be edit.
