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

Alerting with an SQL query?

Hey everyone,

I'm trying to alert on the number of wireless clients across the Orion install. The following SQL returns the count of clients (all access points, all controllers):

SELECT SUM(NPM_NV_WL_APS.ClientsCount) as TotalClients

FROM NPM_NV_WL_APS WHERE AP_Name is not null

What I would like to do is send an alert if this total should fall below 1000 clients, so a HAVING clause such as:

HAVING SUM(NPM_NV_WL_APS.ClientsCount) < 1000

Should do it (and appears to in SSMS).

Any suggestions on getting this working with advanced alerts?

Dave

Find more posts tagged with

Accepted answers

dshpritz

Thanks for the response. I did get this working. I had to hit the DB directly, and it may be overridden later is someone messes with it, but basically I ran something like this on an existing alert:

-- Start SQL --

UPDATE AlertDefinitions
SET AlertDescription = 'This is a custom alert which will alert if there are less than 1000 clients connected accross the enterprise. DO NOT EDIT.'
, TriggerQuery = 'SELECT <node ID> as NetObjectID ,''<some name>'' as Name FROM NPM_NV_WL_APS WHERE AP_Name is not null HAVING SUM(NPM_NV_WL_APS.ClientsCount) <= 1000'
, ResetQuery = 'SELECT <node ID> as NetObjectID ,''<some name>'' as Name FROM NPM_NV_WL_APS WHERE AP_Name is not null HAVING SUM(NPM_NV_WL_APS.ClientsCount) > 1000'
, ObjectType = 'Node'
WHERE AlertName = 'Alert me when there are a low number of wireless clients'

-- End SQL --

The NodeID is a static ID with points to an object with the same name as given in the Name (also static).

I think this would be a nice feature to add, that is, the ability to not just look at an individual node or device, but the enterprise as a whole, and then alert on it.

Thanks,

Dave

All comments

qle

I don't see any way to do this with the Alert Manager. If don't need immediate notification for this and you're willing, you can certainly create a scheduled daily report that is delivered to you via e-mail.

dshpritz

Thanks for the response. I did get this working. I had to hit the DB directly, and it may be overridden later is someone messes with it, but basically I ran something like this on an existing alert:

-- Start SQL --

-- End SQL --

The NodeID is a static ID with points to an object with the same name as given in the Name (also static).

I think this would be a nice feature to add, that is, the ability to not just look at an individual node or device, but the enterprise as a whole, and then alert on it.

Thanks,

Dave