SWQL query to specify specific VM for alert?

Hey all,

Currently I am using this query as the trigger condition for drive space alerts.
where VirtualMachines.VirtualVolumes.SpaceUtilization >= 94

I'm creating a new alert that is specific to a certain VM that has different storage needs. How can I modify this query to specify the VM I want to monitor?

TIA

Find more posts tagged with

swql query

orion

SWQL

Alerts

Accepted answers

kpmarcin

Hi @itguy1024

If you want to filter the VMAN alert using VM name, it is very simple:

SELECT VirtualMachines.Uri, VirtualMachines.DisplayName FROM Orion.VIM.VirtualMachines AS VirtualMachines

where VirtualMachines.VirtualVolumes.SpaceUtilization >= 94 and VirtualMachines.DisplayName = 'Win2019-Fileshare'

Or are you looking for other filtration options?

All comments

KMSigma.SWI

Why are you using SQL for this? You should be able to do it out of the box in the Alert editor.

itguy1024

The alert editor does not work for VMAN orion to get space utilization on individual volumes.
VMAN Orion uses the total sizes from all volumes to examine the storage utilization.

I worked with a tech from solarwinds on this a few months ago. They referenced this article and helped get the alerts working again as they used to in standalone VMAN.

support.solarwinds.com/.../Need-to-find-proper-way-to-alert-on-individual-Virtual-Machine-component-volume-space-utilization

I just need assistance on modifying the query to specify a virtual machine name or IP for a new alert we need.

KMSigma.SWI

Ah, I see. Well, I'd do this in SWQL and not SQL so that it will work as database updates are made between versions. I don't have handy access to a VMAN install at the moment, but I'm sure someone else in Alert Lab can probably help.

itguy1024

Apologies, I am using SWQL not SQL for the alerts.

kpmarcin

Hi @itguy1024

If you want to filter the VMAN alert using VM name, it is very simple:

SELECT VirtualMachines.Uri, VirtualMachines.DisplayName FROM Orion.VIM.VirtualMachines AS VirtualMachines

where VirtualMachines.VirtualVolumes.SpaceUtilization >= 94 and VirtualMachines.DisplayName = 'Win2019-Fileshare'

Or are you looking for other filtration options?

itguy1024

I think that did the trick.