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

Advanced Alert for hourly notification

I know nothing about SQL so please bear with me. I need a notification sent out hourly that will list the node names that are either down or in an unknown state. The timing is not a problem, but the SQL statement for the trigger message is. This is the SQL statement I have so far but it only returns a single node name that is down when I have more than one that is down.

${SQL:Select Caption from Nodes where ((Status = '2') or (Status = '0'))}

Thanks for any help.

Find more posts tagged with

report_scheduler

Accepted answers

All comments

grantsewell

If you've got the timing down, don't worry about advanced SQL commands - can't you just use this?

Trigger Alert when all of the follwoing apply
Node Status is not equal to up

tkryan

Tried that. It sends a singe email for every down node rather than a single email listing all the down nodes.

grantsewell

Apologies - I overlooked the "single email for multiple nodes" part of your post.

I've wanted to implement something like this in my network for awhile. I don't believe that Orion's alert generator is powerful enough to handle this kind of an alert.

However, another option, which isn't available yet, but I would imagine could be done, is using report scheduler. Create a report of all down nodes and customize it to your liking, then have the report scheduler email that report to you hourly.

Denny / Mark - The frequency levels in the report scheduler only go as low as Daily - is there a way around this, or is it planned possibly to add an "Hourly" option in the future?

Network_Guru

I was going to suggest using the report scheduler for this as well.
The report scheduler actually uses the Microsoft Task Scheduler so it should be fairly easy to find the Orion job you've created and run it every hour using the task scheduler instead.

Open up Report Writer and select Settings.
Under the Columns tab, add Program.

Actually if you open up MS Scheduled Tasks you will already see the Orion jobs listed.
Simply select Advanced under the Schedule Tab of the job and select - Repeat Task - every hour.