Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

How to get result of SWQL query into variable for alert processing

akaushik-pp

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.

Find more posts tagged with

Accepted answers

All comments

bobmarley

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.

akaushik-pp

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.