Guest storage space utilisation Alert - Including Mount Point in the Email Alert

grantallenby

Hi All,

Does anyone know how to get the Mount point into the email alert?

So far I have...

VM: ${N=SwisEntity;M=Name}

Free Space in Percent: ${N=SwisEntity;M=VolumeSummaryFreeSpacePercent}

Free Space: ${N=SwisEntity;M=VolumeSummaryFreeSpace}

Capacity: ${N=SwisEntity;M=VolumeSummaryCapacity}

Estimated deplation date: ${N=SwisEntity;M=VolumeSummaryCapacityDepletionDate}

But can't find the SWSQL for Mount Point Name

Find more posts tagged with

email alert

vman - virtualization manager

Accepted answers

All comments

sturdyerde

There are several variables that you can use to show the mount point label in your alert configuration's message. I use ${N=SwisEntity;M=FullName} in my volume alerts. You may want to change your alert configuration to monitor the object type "volume" instead of the object type "VM". Otherwise, you will have to use SWQL and join the VMs tables with the Volumes tables.

vaclav.hanselka

Hi,

If you want address each Volume separately you can not use SWIS query builder but it can be done with custom SWQL query.

Which should look like this but please verify that SpaceUtilization threshold value is what you require.

WHERE VirtualMachines.PowerState = 'poweredOn' AND

VirtualMachines.VirtualVolumes.SpaceUtilization >= 90

And then the message

The following Virtual Machine has a volume that is low on Free Space:

Virtual Machine: ${N=SwisEntity;M=Name}

Volume Name: ${N=SWQL;M=SELECT TOP 1 VirtualMachines.VirtualVolumes.MountPoint FROM Orion.VIM.VirtualMachines AS VirtualMachines WHERE VirtualMachines.VirtualMachineID=${N=SwisEntity;M=VirtualMachineID} AND VirtualMachines.VirtualVolumes.SpaceUtilization>=90 ORDER BY VirtualMachines.VirtualVolumes.SpaceUtilization DESC}

Total Capacity: ${N=SWQL;M=SELECT TOP 1 (VirtualMachines.VirtualVolumes.Capacity)/1073741824 AS Capacity FROM Orion.VIM.VirtualMachines AS VirtualMachines WHERE VirtualMachines.VirtualMachineID=${N=SwisEntity;M=VirtualMachineID} AND VirtualMachines.VirtualVolumes.SpaceUtilization>=90 ORDER BY VirtualMachines.VirtualVolumes.SpaceUtilization DESC} GB

Percent Used: ${N=SWQL;M=SELECT TOP 1 VirtualMachines.VirtualVolumes.SpaceUtilization FROM Orion.VIM.VirtualMachines AS VirtualMachines WHERE VirtualMachines.VirtualMachineID=${N=SwisEntity;M=VirtualMachineID} AND VirtualMachines.VirtualVolumes.SpaceUtilization>=90 ORDER BY VirtualMachines.VirtualVolumes.SpaceUtilization DESC} %

My result looks like this but feel free to add anything you need from VirtualMachines.VirtualVolumes

Unfortunately this is limited to one volume per VM since custom SWQL alerts can only display one entity at the time. This can be fixed by managing VMs as Nodes then Orion collects more information for volumes which can be accessed directly.

pratikmehta003

Full name variable should help you...