I've been able to create an alert to trigger if Volume Capacity is below a value, but I need to included the Volume Capacity in the alert message - can anyone provide help?
Total size ${VolumeSize} -- should be volume capacity
Free space ${VolumeSpaceAvailable}
Percent used ${VolumePercentUsed}
From experience you probably want to add some CASE statements, that said:
Estimated days until full: ${N=SWQL;M=SELECT TOP 1 DaysToCapacityAvgFROM Orion.VolumesForecastCapacityWHERE InstanceID = ${N=SwisEntity;M=VolumeID} }(Using the last week of data)
Estimated days until full: ${N=SWQL;M=SELECT TOP 1 DaysToCapacityAvg
FROM Orion.VolumesForecastCapacity
WHERE InstanceID = ${N=SwisEntity;M=VolumeID} }
(Using the last week of data)
