3 Replies Latest reply: May 19, 2010 6:17 AM by scottd RSS

SQL Variable for Alerts - Query help


Hi folks,

I am trying to build a SQL Variable in Advanced Alerts that will list the first three characters of a string/line.

What i'm trying to achieve is having a disk label C:\, D:\ or E:\ be displayed in the alert message, instead of Volume ID, serial and what not.
A Volume Variable according to the administrator guide exists for this - ${Caption} (User friendly volume name).

The SQL variable to use in my case would be ${SQL:Caption<sql query>}

Could anyone help me fill out the <> with something that actually works?