Submit a ticketCall us

AnnouncementsWeb Help Desk Integrations eCourse

Looking to reduce response times? Sign up for our eCourse to learn how integrating Web Help Desk with Dameware Remote Support, Network Configuration Manager, Network Performance Monitor, and Server & Application Monitor can improve communication efficiencies.

Register here.

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: 1,281 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