Hi,
I am attempting to create a report to highlight fixed disk utilisation spikes over the last 24 hours.
I have tried to create a report, that compares the current disk utilisation with the historical disk utilisation, specified time frame = last 24 hours.
This is the SQL;
SELECT TOP 10000 Convert(DateTime,Floor(Cast((DateTime) as Float)),0) AS SummaryDate,
Nodes.NodeID AS NodeID,
Nodes.Caption AS NodeName,
Nodes.Application AS Application,
Volumes.VolumeDescription AS Volume_Description,
AVG(VolumeUsage.AvgDiskUsed) AS AVERAGE_of_AvgDiskUsed,
AVG(Volumes.VolumeSpaceUsed) AS AVERAGE_of_VolumeSpaceUsed
FROM
(Nodes INNER JOIN Volumes ON (Nodes.NodeID = Volumes.NodeID)) INNER JOIN VolumeUsage ON (Volumes.VolumeID = VolumeUsage.VolumeID)
WHERE
( DateTime BETWEEN 41365.5833333333 AND 41366.625 )
AND
(
(Volumes.VolumeSpaceUsed > VolumeUsage.MaxDiskUsed) AND
(VolumeUsage.AvgDiskUsed < Volumes.VolumeSpaceUsed) AND
(Volumes.VolumeDescription NOT LIKE '%RAM%') AND
(Volumes.VolumeDescription NOT LIKE '%memory%') AND
(Volumes.VolumeDescription NOT LIKE '%page%') AND
(Volumes.VolumeDescription NOT LIKE '%pool%') AND
(Volumes.VolumeDescription NOT LIKE '%Call%') AND
(Nodes.Caption NOT LIKE '%SOL%')
)
GROUP BY Convert(DateTime,Floor(Cast((DateTime) as Float)),0),
Nodes.NodeID, Nodes.Caption, Nodes.Application, Volumes.VolumeDescription
ORDER BY SummaryDate ASC
Below is a sample of the results returned;
It can be seen that whilst the query is working, retruning results as expected (in black), the query is also returning values that are are identical for disk utilisation over the past 24 hours (highlighted in red)
My only reasoning for this is that SolarWinds is liekly to be computing upto the very last byte of data, whereas above, the utilisation is displayed in a rounded up manner to 0.1 GB.
How does one go about eliminating the volumes, with the same utilisation, over the last 24 hours (highlighted in red) - in order to end up with a report, which ONLY highlights volumes that have increased over the last 24 hours?
