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

Alert only on C: or /

Currently I have alerts for any volume that exceeds 98% utilization. I need to set up an additional set of alerts that trigger at 95% for only C: or / (root) volumes. I have a SQL query that should be able to help me set up the alert:

From there I could set up the alert to trigger only if the Caption is "C:" or "/", but I don't know how I can add this SQL query into the trigger conditions on the alert.

Find more posts tagged with

Accepted answers

jangliss

Your alert conditions should say something like this:

Trigger Alert when all of the following apply

"Volume Percent Used" is greater than 95

Trigger Alert when ANY of the following apply

"Volume Caption" is equal to "/"

"Volume Caption" is equal to "C:"

The other option is to base it off of warning/critical conditions, and adjust the values for those volumes, but that might be a little more work.

All comments

jangliss

Your alert conditions should say something like this:

Trigger Alert when all of the following apply

"Volume Percent Used" is greater than 95

Trigger Alert when ANY of the following apply

"Volume Caption" is equal to "/"

"Volume Caption" is equal to "C:"

The other option is to base it off of warning/critical conditions, and adjust the values for those volumes, but that might be a little more work.

bhilgenkamp_botw

After I had a cup of coffee I realized this is a much better approach:

But for future knowledge I would still be interested in finding out how to create a custom query like the above in a trigger condition.

bhilgenkamp_botw

Thanks Jonathan. I had not refreshed the page yet when I posted the below. At least I know I did it correctly now

jangliss

A little tip for you, once you've created your alert and it works how you want it to, and you wish to see the actual code behind it, change the "Type of Property to Monitor" from say Volumes, to "Custom SQL Alert", it'll show the final output SQL.

Before:

After:

This isn't exactly the same as your alert, but you can see how it works, and the syntax for the where clause. You can also see all the parenthesis that calculate between the AND and ORs in the query.