I have vMan integrated with SAM 6.3. I'd like to generate alerts when one of more VM disk's available free space is say hits 10% of the capacity. I found there is a field on each VM object:
SELECT DisplayName, volumeSummaryFreeSpacePercentage FROM [dbo].[VirtualMachinesView]
However this field is the total free disk space % of all the volumes in the VM. The field does not reflect anything if one of the disks is full but the overall is not.
I also have a SQL statement to query VM disk if above the threshold hold.
SELECT vm.Name, vol.VirtualMachineID, vol.MountPoint, vol.Capacity, vol.FreeSpace, Cast(vol.FreeSpace as decimal)/vol.Capacity FROM VIM_VirtualMachineVolumes as vol LEFT JOIN VIM_VirtualMachines as vm ON vm.VirtualMachineID = vol.VirtualMachineID WHERE Cast(vol.FreeSpace as decimal)/vol.Capacity < .1
I can find a way to insert this custom SQL statement to the Edit Alert wizard. Both these have pre-built SQL statement:
Any pointer is appreciated.
