4 Replies Latest reply: May 16, 2012 10:51 AM by zhollett RSS

Advanced Alert Manager - Trigger Actions Mail

zhollett

Hello,

I am attempting to include a piece of specific information regarding a Volume's Percent Free Space included in the Email.

 

The variables in the Message section are not providing the Percent Free.  I can use PercentUsed but I need to get PercentFree in the E-mail.

 

I can get this easily when I create an SQL query which looks like this:

 

Select (100 - Volumes.VolumePercentUsed) AS PercentFree
From Volumes
Where Volumes.VolumeID = 1345

 

I have tried putting that into a variable in the Message section but when I attempt to use the variable for the VolumeID, it balks on the second curly brace "}" and fails.

 

I then thought to include just the beginning of the Select string. 

Select (100 - Volumes.VolumePercentUsed) AS PercentFree
From Volumes

 

The math works now, but it only selects the first volume in the Volumes Table, not the actual volume in question.

 

How do I get the SQL to do math on the VolumePercentUsed from the Volume which generated the alert included in the Email.

 

Thanks for reading.

Zach