Is it possible to change the value used for the Projected Runout in the Capacity Summary widget in SRM?
How can this be changed to a value like 3 months?
Try SWQL Like:
SELECT SRM_V.StorageArray.Caption AS [StorageArray], SRM_V.Pools.Caption AS Pool, SRM_V.Caption AS [StorageVolume], SRM_V.CapacityAllocated AS [VSpace], SRM_V.CapacityFreePercentage, SRM_V.CapacityRunoutDate as[Projected Runout Date], MONTHDIFF(GETUTCDATE(), SRM_V.CapacityRunoutDate) as [Months to runout] FROM Orion.SRM.Volumes SRM_V Where MONTHDIFF(GETUTCDATE(), SRM_V.CapacityRunoutDate) < 4
Its maybe not exactly what you would like but it should get you close.
Also, take a look in SWQL Studio to see the other data in the same table.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.