cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Need to Forecast on fixed disks

Jump to solution

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

0 Kudos
1 Solution
Level 11

and nodes.Volumes.Type = 'Fixed Disk' 

View solution in original post

2 Replies
Level 11

and nodes.Volumes.Type = 'Fixed Disk' 

View solution in original post

Your missing the "SELECT" part of your query?   Plus I think you're missing one of the tables your looking at?  (ie: VolumesForecastCapacity)