5 Replies Latest reply on Aug 26, 2015 3:58 PM by KMSigma

    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?