How do I change this query to only monitor the fixed disks and not all volumes on a node? Sorry, my SWSQL is very limited. Thanks.
LEFT JOIN Orion.Nodes nodes on nodes.NodeID = VolumesForecastCapacity.NodeID
LEFT JOIN Orion.Settings s ON s.SettingID = 'ForecastMinDays'
VolumesForecastCapacity.DaysToCapacityAvg <= 10
AND VolumesForecastCapacity.MetricName = 'Forecast.Metric.PercentDiskUsed'
AND DayDiff(VolumesForecastCapacity.MinDateTime, VolumesForecastCapacity.MaxDateTime) >= ISNULL(s.CurrentValue, 7)
AND nodes.Unmanaged = false
Solved! Go to Solution.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.