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:\, \ 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?

Find more posts tagged with

advanced_alerts

advanced_alert_setup_question

sql_variable

variable

Accepted answers

This is one way you can do it;

${SQL:Select Substring ('${Caption}',1,3) AS Caption}

This thread may help you as well.

All comments

This is one way you can do it;

${SQL:Select Substring ('${Caption}',1,3) AS Caption}

This thread may help you as well.

Hi Scott,

Thank you. It was tested and it works.
This is exactly what i needed.

Cool!

Glad you got it sorted out.

what about if i want the first word? like HELLO WORLD and i want the HELLO output only? thank you

Quick Links