Hi All,
can anyone help with the creation of a custom SQL report? (I have exceeded my capabilities!)
I've deployed a Custom Poller to extract capacity/usage information from my NetApps which returns values into NetAppVolPercentUsed
I've managed to create a report to extract the current overall capacity (aggr0 is the specific row I'm interested in) using the SQL below
SELECT Nodes.Caption AS NodeName
, cp.UniqueName AS Poller_Name
, cl.Label
, Nodes.NodeID
, cs.Status AS Status
FROM Nodes INNER JOIN CustomPollerAssignment ca ON (Nodes.NodeID = ca.NodeID)
INNER JOIN CustomPollers cp ON (ca.CustomPollerID = cp.CustomPollerID)
INNER JOIN CustomPollerStatus cs ON (ca.CustomPollerAssignmentID = cs.CustomPollerAssignmentID)
INNER JOIN CustomPollerLabels cl ON (ca.CustomPollerAssignmentID = cl.CustomPollerAssignmentID AND cs.RowID =cl.rowid)
WHERE cp.UniqueName = 'NetAppVolPercentUsed' AND cl.Label = 'aggr0'
What I would like to have is a report showing the average capacity of each NetApp (ie. aggr0) by day for the last 30 days. Can anyone help?