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

Is it possible for the application to create a alert incident if a SQL table has more than 100 records sitting in the queue?

Hi, Is it possible for the application to create an alert incident if a SQL table has more than 100records sitting in the queue?

Find more posts tagged with

Accepted answers

All comments

RichardLetts

yes.

what Object do you want to raise the alert on?

write yurself a SQL query that returns true

select count(*) from table having count(*)>100

then

create a NODE custom SQL alert

with the condition:

WHERE

exists (select count(*) from table having count(*)>100)

AND nodeid=####

beyond that you'll have to experiment.

paraphrasing Edison: "you will have not failed 1,000 times. You will have successfully discovered 1,000 ways to NOT make a get the alert to work. ... "

er.vansh17091

Hi, Thank you. I am trying to create the same but not getting an output.Can you please share the output screenshot?