When creating an Custom SQL Alert you select which database table the alert will be querying such as Nodes, groups, volumes, etc. as pictured below. More information can be found in the Administrators guide
Yes I understand the Alert trigger using SQL ( I am joining the NODES and the Volume Table..
MY question is not the trigger but the alert: CAN I use a stored procedure in the alert section.. I.E. I want to parse out a field that has more than one element , and some junk.. i want to make it readable.. for the Email..
The Trigger condition is attached
The Alert is Here: -EMAIL
The first part: BASIC ORION
${Node.EmailTo}
Maintainer: ${Node.Maintainers}
Name (Alias): ${Node.ServerAlias}
Server Name: ${Node.Caption}
Server Class: ${Node.Cls}
System(s) : ${Node.System}
Applications: ${Node.Applications}
Second Part HTML with some SQL:
<B>Alert: </B>
<span style='color:red'> -Current Volume space available: ${VolumeSpaceavailable} / Critical Threshold::
${SQL:Select round((CT/1024/1024/1024),3) from volumes where fullname ='${fullname}'} GB
System Link: \\${Node.caption}:${SQL:Select substring (caption,1,1) from volumes where fullname ='${fullname}'}
Full Name: ${FullName}
Caption (V): ${Caption}
<span style='color:black'> Operations:
• For </span><B><U><span style='color:red'> Critical threshold disk space alerts
</b></span> </U> <span style='color:black'> very instructional message for operations...yada yada yada.
• For </span><B><U><span style='color:Orange'> Warning threshold disk space alerts
</b></span> </U> <span style='color:black'>very instructional message for operations...yada yada yada.
• For </span><B><U><span style='color:blue'> Normal threshold disk space alerts
</b> </U> </span> <span style='color:black'> very instructional message for operations...yada yada yada.
<B> Details on this Node and the services can be found here: </B></span>
<B><U><span style='color:Blue'> Volume: ${VolumeDetailsURL} </b></span> </U>
<B><U><span style='color:Pink'> NODE: ${Node.NodesDetailsURL} </b></span> </U>
To Acknowlege this alert please click here: ${AcknowledgeURL}
Alert Name: ${AlertName}
Without seeing the result of the SQL query itself it's difficult say exactly. Provided your SQL query returns a single column/row value then I don't see any reason why it wouldn't work.
