1 Reply Latest reply on Aug 16, 2009 8:01 AM by jbaulsir

    Advanced Alerting

    darkshooter

      I have an advanced alert configured to email me when physical memory on a server reached 85%. The alert works, but when it displays the percent in use it has several decimal places; see below:

       

             

      Percent Memory Used on KPRINT1 is 83.12118

       

      Is there any way to make it so it only shows 83 instead of 83.12118?

        • Re: Advanced Alerting
          jbaulsir

          Try this:

          Alert: ${FullName} is ${SQL:Select Round ('${VolumePercentUsed}',0) from Volumes WHERE VolumeID='${VolumeID}'} Percent Utilized

          Volume Size        ${SQL:Select round((VolumeSize / 1024 / 1024 / 1024),1) from Volumes WHERE VolumeID='${VolumeID}'} GB
          Currently Used     ${SQL:Select round((VolumeSpaceUsed / 1024 / 1024 / 1024),1) from Volumes WHERE VolumeID='${VolumeID}'} GB

           

          JB