Email Alert with hidden share information

ebonfield

I would like to receive an email when a volume exceeds a certain size which contains the hidden share UNC path.

For example, im my message body I have the following:

Volume \\${Node.Caption}\${SQL:Select Substring ('${Caption}',1,3) AS Caption}

This provides me with \\servername\drive letter = \\servername\C:\

I would like to add the UNC path to actual hidden share so it will look like \\servername\C$.

This would enable the support team to simply click on the unc to the share which has been alerted.

Is there a simple way of doing this? I sinmply want to drop off the and replace is with a $ sign.

 

Thanks

sedmo

Try this.

Volume \\${Node.Caption}\${SQL:Select Substring ('${Caption}',1,1) + '$'  AS Caption}