Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Network Performance Monitor (NPM) > NPM email alert shows inaccurate value for the variables: {$VolumeSpaceAvailable}

NPM email alert shows inaccurate value for the variables: {$VolumeSpaceAvailable}

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 76 Votes: 0 Revisions: 8

Issue:
 The NPM email alert on 'remaining space in volume' shows inaccurate values when the following custom SQL query is used:

${Caption} volume on ${Node.Caption} has ${SQL:Select round((VolumeSpaceAvailable / 1024 / 1024),1) from Volumes WHERE VolumeID='${VolumeID}'}


Cause:
The alert variable {$VolumeSpaceAvailable} in the Custom SQL is misconfigured


Resolution

  1. Replace the following code in Custom SQL
    ${Caption} volume on ${Node.Caption} has ${SQL:Select round((VolumeSpaceAvailable / 1024 / 1024 / 1024),1) from Volumes WHERE VolumeID='${VolumeID}'}
  2. Now, the email alerts should render accurate values, as the string shown above will divide the value in VolumeSpaceAvailable until it is in GB and rounds to the tenth decimal place.

custom sql.jpg

Last modified

Tags

Classifications

Public