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'
WHERE
VolumesForecastCapacity.DaysToCapacityAvg <= 10
AND VolumesForecastCapacity.MetricName = 'Forecast.Metric.PercentDiskUsed'
AND DayDiff(VolumesForecastCapacity.MinDateTime, VolumesForecastCapacity.MaxDateTime) >= ISNULL(s.CurrentValue, 7)
AND nodes.Unmanaged = false
