Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Disk alerting with drive letter only variable

Hello,

I am working on setting up disk alerting on our new solarwinds setup and i want to to have the drive letter only as part of the title.

Like this "c:\" instead of "c:\OS volume"

I ran across this article from 2010 and can get it to work in simulation but when the alert occurs in real time i get this output "${C " for every drive letter instead of the correct output.

Advanced Alert - First one!

This is the string I was using: ${SQL:Select Substring ('${Caption}',1,3) AS Caption}

Does anyone know how to get only the drive variable working

*UPDATE*

Upon Further testing It works with the Initial alert but we want it to realert daily. when the subsequent alerts come out the variable is messed up

Thank you for the help

Find more posts tagged with

Accepted answers

bschieck

After working with support this was the variable that ended up working on version 2019.4

${SQL: SELECT SUBSTRING (Caption,1,3) FROM Volumes WHERE VolumeID = ${N=SwisEntity;M=VolumeID}} and works everytime

Thank you for your help

All comments

KMSigma.SWI

That post is from 10 years ago and the syntax of the custom variables has changed significantly - you're lucky that it worked.

I just tested this and it appeared to have worked:

${N=SWQL;M=SELECT SUBSTRING(Caption,1,3) AS Caption FROM Orion.Volumes}

I'm not sure why you would want to show "less" information, but that's up to you. Just realize that this will substring ANY monitored volume (Swap Space --> 'SWA', Physical Memory --> 'Phy', etc.). This could also be really problematic if you use mount points or NFS shares because all the "identifiable" information will be truncated off.

Welcome to THWACK and SolarWinds! Ask whatever questions you'd like. The community is here to help.

bschieck

The idea is to shorten the title for mobile devices to see more of the alert.

I am targeting Fixed Disk and mounts in the trigger conditions to get rid of the extra info

for my title i used this variable string: CAPACITY: ${NodeName} Volume ${SQL:Select Substring ('${Caption}',1,3) AS Caption}} Disk Utilization ${N=SwisEntity;M=VolumePercentUsed}

For the first alert i would get this response: "CAPACITY: Server Volume C:\ Disk Utilization 100 %" (or if it wasnt the c drive it would be the correct drive letter)

For the Subsequent alerts i would get this responce "CAPACITY: Server Volume ${C Disk Utilization 100 %" (For any drive letter that would be alerting)

This is what it looks like with your variable: "CAPACITY: ${NodeName} Volume ${N=SWQL;M=SELECT SUBSTRING(Caption,1,3) AS Caption FROM Orion.Volumes} Disk Utilization ${N=SwisEntity;M=VolumePercentUsed}"

And get this output for all responses; first or subsequent "CAPACITY: Server Volume Slo Disk Utilization 100 %"

it didn't seem to like it.

bschieck

After working with support this was the variable that ended up working on version 2019.4

${SQL: SELECT SUBSTRING (Caption,1,3) FROM Volumes WHERE VolumeID = ${N=SwisEntity;M=VolumeID}} and works everytime

Thank you for your help