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

    Advanced Alert Manager - Trigger Actions Mail



      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.