Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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: 23 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