volume capacity on servers

trilobite_rex

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

I want to take this canned query and make it so that it shows for servers only, how do I do this?

ctlswadmin

Hey Trilobite,

Custom properties would be the most effective way. Or, you could filter by vendor.

Example:

WHERE

  VolumesForecastCapacity.DaysToCapacityAvg <= 60

  AND VolumesForecastCapacity.MetricName = 'Forecast.Metric.PercentDiskUsed'

  AND DayDiff(VolumesForecastCapacity.MinDateTime, VolumesForecastCapacity.MaxDateTime) >= ISNULL(s.CurrentValue, 7)

  AND  nodes.Unmanaged = false