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

Triggering an alert when node was down 3 times

Hi,

Is there any way to create an alert to trigger when a node was down 3 times in a period of one hour ?

Find more posts tagged with

Accepted answers

All comments

yes, you can create a custom sql alert and search for the down event for that one node in the past hour and alert on that...

I found this sql query in Thwack:

select TOP 5 cast(message as varchar(200)) as EventMsg, COUNT(*) as Occurances

from Events

where eventtime >dateadd(hour,-1,getdate()) AND Message like '%down%'

group by cast(message as varchar(200)),EventType

having count(*)>=3

order by Occurances DESC

How could I change this query to show me node name and insert a custom property ?

Thanks

Quick Links