I recently upgraded to v8.1 and I am still playing around advanced alerting. I am having two issues.
The first issue is with the field VolumeType in the Volumes table. In this field, there are options like Fixed Disk, Virtual Memory, RAM and Unknown. I am trying to make an alert that will only alert on Fixed Disk that says "Vendor = Windows" and "VolumeType = Fixed Disk" and "Volume Percent Used >= 80". However, when I configure this alert, I get the same results as if I left out the "VolumeType = Fixed Disk" condition. I have tried doing other things like "VolumeType != RAM", but alerts still trigger for RAM. I have tried using advanced conditions and that doesnt help and I have tried reorder the list, but that doesnt help. What am I missing here?
The other issue is in regards to output from variables in email alerts. In the same alert that I am creating, in the subject line of the alert I am displaying the ${Volumes.VolumePercentUsed} variable. However, in the Volumes table this field is in the format ##.####. I know with basic alerts, I can add -Cooked at the end of the variable to get a two digit number but I am having trouble finding that same option with advanced alerting. I do not want people to have to see a value out to the ten thousandth decimal place. What can I do for this?
Does anyone have any idea about this?
try Volumes.VolumeType='Fixed Disk' maybe?
http://thwack.com/forums/p/3874/16870.aspx#16870
I looked at that other post you linked to but that person was doing a filter on the webpage. I am actually trying to setup the alert. I attached the image of the what I have in my alert.
1) Looks like that should work.
2) No way to round the number, even with a SQL query because the query can't be passed the VolumeID
This works as a SQL query
IE: ${SQL:SELECT Round(VolumePercentUsed,2) FROM Volumes WHERE VolumeID='${VolumeID}'}
But Alerts will always give VolumeID=1
I got this setup and working today. Works good and it returns the correct values.