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
Store

round function

I'm creating an alert message using swql. I can't find a way to round off the values from these queries.

I'd like to round down to 2 decimals for percentages and disk free space from Byte (B) to GB (GB).

VM is ${N=SWQL;M=SELECT Volumes.SpaceUtilization

FROM Orion.VIM.VirtualMachines AS VM JOIN Orion.VIM.VirtualMachineVolumes AS Volumes ON VM.VirtualMachineID = Volumes.VirtualMachineID

WHERE Volumes.SpaceUtilization > 50 AND VM.VirtualMachineID = ${N=SwisEntity;M=VirtualMachineID}}% full.

Free Space: ${N=SWQL;M=SELECT Volumes.FreeSpace FROM Orion.VIM.VirtualMachines AS VM

JOIN Orion.VIM.VirtualMachineVolumes AS Volumes ON VM.VirtualMachineID = Volumes.VirtualMachineID

WHERE Volumes.SpaceUtilization > 50 AND VM.VirtualMachineID = ${N=SwisEntity;M=VirtualMachineID}}B of ${N=SWQL;M=SELECT Volumes.Capacity FROM Orion.VIM.VirtualMachines AS VM JOIN Orion.VIM.VirtualMachineVolumes AS Volumes ON VM.VirtualMachineID = Volumes.VirtualMachineID

WHERE Volumes.SpaceUtilization > 50 AND VM.VirtualMachineID = ${N=SwisEntity;M=VirtualMachineID}} B

Here is the output:

VM is 99.977775139086% full.

Free Space: 35794944B of 161058123776 B

Find more posts tagged with

Accepted answers

All comments

jeilers

I think the function you are looking for is round(n, p)

I found this on the wiki
SWQL Functions · solarwinds/OrionSDK Wiki · GitHub

Let me know if that is what you are looking for.

jkcy

I tried this but didn't work:

VM ssasvdp3733 \ is ${N=SWQL;M=SELECT ROUND(Volumes.SpaceUtilization,2)

FROM Orion.VIM.VirtualMachines AS VM JOIN Orion.VIM.VirtualMachineVolumes AS Volumes ON VM.VirtualMachineID = Volumes.VirtualMachineID

WHERE Volumes.SpaceUtilization > 50 AND VM.VirtualMachineID = 481519}% full.

jeilers

try adding
ROUND(Volumes.SpaceUtilization,2) as SpaceU

jkcy

Works. Thanks.

To convert Bytes to GB, I have to /1024 several time. The /(1024^3) doesn't work. I'll just go with /1024/1024/1024 for now like this:

ROUND(ToString(Volumes.FreeSpace/1024/1024/1024),2)