Modifying Alert Variable Length

Question

Hi,

I am very new to Alerts in NPM (currently running v9.1 in MS/SQL2005-Std) and need to generate emails when certain conditions arise - fairly straight forward & I have largely achieved this.

The problem is that some of the variables contain way too much data to be useful, especially in an email subject.  Typical example is the "Caption" for a Volume.  I have created an Alert to notify me by email if the "C" or "D" drive of a group of servers drops below a threshhold. I want to place the Drive letter in the Subject, however it is (way) too long (eg: "C:\ System+Data  245a47af").

I would like to display just the first character of the Caption in the Email Subject - is this possible??

Thanks in advance

sk_5910 · Answer

It worked like a charm (exactly what I wanted).

Many (many) thanks.

qle · Answer

See if the following works for you in the subject line:

${SQL:Select substring(caption,1,2) from volumes where volumeid=${volumeid}}