Disk Usage Email Elerts

Hello, i'm trying to setup disk usage alerts that report when the disk space is below 10% of its capacity.

Some of my servers have multiple drives on then ie: C:\ R:\ S:\.

When i received the email alert i'd like it to report the drive letter that has the space issue. Currently it reports the drive letter and label.

Is there a way i can configure it to just report the drive letter?

Attached is my configuration and a samle email.

Thanks for your help.

Find more posts tagged with

Change ${Caption} to ${SQL: Select Left (Caption, 2) From Volumes} and see if that works for you

Change ${Caption} to ${SQL: Select Left (Caption, 2) From Volumes} and see if that works for you

That worked perfectly.

Thanks for your help.

I've just notices all drives are reporting as C: drive now. Even S:\ and R:\ drives.

Do you know how to have it repor the correct drive letter?

Thanks

Thought i'd let you know i got it reporting the correct drive letter by using the following:

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