I can pull current load metrics on my unix boxes with this sort of search. I need to pull the same sort of thing for the last 24 hours. Can someone point me in the right direction on where I should be looking?
SELECT DISTINCT CustomPollerAssignmentView.CustomPollerAssignmentID AS NetObjectID, CustomPollerAssignmentView.AssignmentName AS Name
FROM ((CustomPollerStatus INNER JOIN CustomPollerAssignmentView ON (CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignmentView.CustomPollerAssignmentID)) LEFT OUTER JOIN CustomPollers ON (CustomPollerAssignmentView.CustomPollerID = CustomPollers.CustomPollerID)) INNER JOIN Nodes ON (CustomPollerAssignmentView.NodeID = Nodes.NodeID)
WHERE
(
(Nodes.Caption LIKE '%theHostnameOfMyComputers%') AND
(CustomPollers."OID" = '1.3.6.1.4.1.2021.10.1.3') AND
(CustomPollerStatus."RowID" = '3') AND
(CustomPollerStatus.Status > '0.01')
)
AND
(
(InterfaceID = 0)
)
;
I hope I'm posting in the right forum. If not, tell me where to go and I'll move aside.
Thanks,
Dan
EDIT
Seems like I just needed to keep poking at it:
SELECT TOP 5 *
FROM ((CustomPollerStatus INNER JOIN CustomPollerAssignmentView ON (CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignmentView.CustomPollerAssignmentID)) LEFT OUTER JOIN CustomPollers ON (CustomPollerAssignmentView.CustomPollerID = CustomPollers.CustomPollerID)) INNER JOIN Nodes ON (CustomPollerAssignmentView.NodeID = Nodes.NodeID)
WHERE
(
(Nodes.Caption LIKE '%p054dmxappa%') AND
(CustomPollers."OID" = '1.3.6.1.4.1.2021.10.1.3') AND
(CustomPollerStatus."RowID" = '3') AND
(CustomPollerStatus.Status > '0.01')
(DateTime >= DATEADD(day, -1, GETDATE()))
)
AND
(
(InterfaceID = 0)
)
;
