How can I modify the 30/60 days forcast alert for fixed disks only? I don't need ram, virtual, etc.
Make a copy of the original alert and add the last line, like that :
SELECT VolumesForecastCapacity.Uri, VolumesForecastCapacity.DisplayName FROM Orion.VolumesForecastCapacity AS VolumesForecastCapacity LEFT JOIN Orion.Nodes nodes on nodes.NodeID = VolumesForecastCapacity.NodeID LEFT JOIN Orion.Settings s ON s.SettingID = 'ForecastMinDays' WHERE VolumesForecastCapacity.DaysToCapacityAvg <= 60 AND VolumesForecastCapacity.MetricName = 'Forecast.Metric.PercentDiskUsed' AND DayDiff(VolumesForecastCapacity.MinDateTime, VolumesForecastCapacity.MaxDateTime) >= ISNULL(s.CurrentValue, 7) AND nodes.Unmanaged = false AND VolumesForecastCapacity.Volume.Type = 'Fixed Disk'
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK© online community. More than 180,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.