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
Store

SQL query to Alert

I have been working for a week on this and have not figured it out. What I want is to have an alert fire from a SQL query.

It is for my CallManager. I have found everything that shows me the number of calls. I am wanting to have SolarWinds send an alert when the number of calls reaches a certain number or higher.

What I have is a Custom SQL Alert. Here is what I have typed in the box:

where custompollerassignmentid = 'e9XXXX2f-0XX8-4XX4-9e07-cXXXXebb32bb' and rowid = '20'

It returns one value in SQL, and I want to find out how to make the Alert system fire when the number returned is 50 or higher.

Find more posts tagged with

Accepted answers

All comments

adatole

Can you past the full query which works in SQL Management studio? and then some sample rows for what you get as a result?

That would help.

FormerMember

SELECT CustomPollerStatusTable.CustomPollerAssignmentID, CustomPollerStatusTable.CompressedRowID, CustomPollerStatusTable.FullLabel FROM CustomPollerStatusTable

where custompollerassignmentid = 'e9XXXX2f-0488-4XX4-9XX7-ca3eXXXXX2bb' and rowid = '20'

But I just found out that it does not return what I thought. If I change the query to:

SELECT * FROM CustomPollerStatusTable

It returns the Rate field. But I cannot get the Rate field from the alert thingy because it defines the top portion of this email.

njoylif

you can include that in your WHERE clause even if not returned.

should be able to just add:

AND Rate >=50

zackm

would it not be easier to use the GUI for this?

FormerMember

How do I add it in the where clause? How do I make an Alert out of it?

FormerMember

I have tried for many days to use the GUI, but to no avail....... it looks like custom SQL queries are the way to go.

zackm

Can you show us a screenshot of the results of this query?

SELECT * FROM CustomPollerStatusTable WHERE CustomPollerAssignmentID = 'e9XXXX2f-0488-4XX4-9XX7-ca3eXXXXX2bb' AND RowID = '20'

FormerMember

2015_03_17_11_09_47_10.10.111.20_Remote_Desktop_Connection.jpg