Hello,
I am new to Solarwinds and I was tasked with finding a way to monitor rapid disk growth for specific servers in our environment. I was able to find a custom SQL query that will alert us if a volume grows X% over a given time period:
LEFT JOIN VolumeUsage_Detail V
ON Volumes.VolumeID = V.VolumeID
AND Volumes.VolumeType = 'fixed disk'
AND DATEDIFF(HH,DateTime, GETDATE()) < 1
GROUP BY Volumes.NodeID, Volumes.VolumeID, Volumes.FullName
HAVING MAX(PercentDiskUsed) - MIN(PercentDiskUsed) > 2
I have tested this query and it works as intended, but it alerts me for the entire server environment. The question I have is there a way I can make it so it only alerts for specific servers? If so (I'm sure there is a way), how?