Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Rounding up/down percentages of variables when passed through as an alert action.

So I have a few alerts where I return a message to the appropriate teams the percentages of the various monitored components. Is there a way to round these percentages up/down to the nearest whole number? Right now I get 15 decimal places returned.

Body of message in the alert action

${ComponentName} is currently up but reporting a status of ${ComponentStatus}

Current CPU Usage ${PercentCPU}% Alert Threshold is ${Threshold-CPU-Warning}%

Current Virtual Memory Usage ${PercentVirtualMemory}% Alert Threshold is ${Threshold-VirtualMemory-Warning}%

Current Physical Memory Usage ${PercentMemory}% Alert Threshold is ${Threshold-PhysicalMemory-Warning}%

Actual data received in the email.

SQL Service Monitoring is currently up but reporting a status of Warning

Current CPU Usage 0.779999971389771% Alert Threshold is 80%

Current Virtual Memory Usage 39.7999992370605% Alert Threshold is 80%

Current Physical Memory Usage 80.1100006103516% Alert Threshold is 80%

Find more posts tagged with

Accepted answers

All comments

netlogix

Try ${SQL: Select CONVERT(int,${<THEAVGVARIABLE})} - that will just chop the decimal point off, not rounding... I don't know that one.