Issue with Advanced Alerting and Fixed Disk

Question

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?

patwill66 · Answer

I got this setup and working today.  Works good and it returns the correct values.

jbaulsir · Answer

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

patwill66 · Answer

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.