Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

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: 64 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
23:12, 22 Jun 2016

Tags

Classifications

Public