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

Cannot Get Advanced Alert to Fire

john.trice

For whatever reason I cannot get this to fire. I believe I have the trigger set correctly. Thoughts?

Thanks

Find more posts tagged with

Accepted answers

john.trice

Resolved I removed

(Volumes.FullName <> '/dev/backuplv') AND

(Volumes.FullName <> '/dev/oraclelv')

)

And replaced it with

(Volumes.Caption <> '/dev/backuplv') AND

(Volumes.Caption <> '/dev/oraclelv')

)

Works like a charm..Thanks for all the help

All comments

zackm

Can you change the drop-down option to 'Custom SQL Alert' and then post a screenshot of the full query?

john.trice

Sure thing...

dnerdahl

You're problem here is your grouping level.

You have the following under your ALL condition

MachineType = 'IBM PowerPC'

VolumeType = 'Fixed Disk'

VolumePercentUsed >= 84

VolumePercentUsed < 94

And the following under your ANY condition

VolumeSpaceAvailable <= 1024

So right now this will only trigger if the Machine type is equal to exactly 'IBM PowerPC' AND the VolumeType is exactly 'Fixed Disk' AND the VolumePercentUsed is greater than or equal to '84' AND VolumePercentUsed is less than 94 AND VolumeSpace Available is less than or equal to '1024'. The way this is currently configured there is no need for the ANY statement.

When you add new basic or complex condition you need to make sure that you have the condition group you want it under highlighted. The up/down arrows or right-click commands do not change the condition group a statement is in... it just moves it vertically in the list.

This is a very specific logic and considering the size of fixed disk drives it is unlikely that you'll have a volume with between 84 and 93 percent utilization that has 1024 or less bytes of space available.

zackm

bingo. Nice explanation!

john.trice

So its in bytes? I was going on that it was based on MB hence the 1024 (1GB) This could be my issue

dnerdahl

Definitely bytes.

For this drive

Capture 1.GIF

The following is stored in the Volumes table (the table being used in the alert select)

VolumeType	VolumeTypeIcon	VolumePercentUsed	VolumeSpaceUsed	VolumeSpaceAvailable	VolumeSize	Status	StatusLED	VolumeResponding
Fixed Disk	FixedDisk.gif	15.91152	34203086848	180754989056	214958075904	1	Up.gif	Y

john.trice

Totally makes sense now. I've removed the "any" statement and converted to bytes.The reason for the < 94 is that I created a second critical alert for > 95 and didn't want to double dinged with two alerts. So logically this should fire