cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Advanced Alerting

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?

1 Reply
Level 13

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