I need to create a report with Node name, IP address, Model, and Serial number. I'd also like to be able to sort it by vendor. I have custom pollers that will get the serial numbers.
You can use NCM to get this info but unfortunately switch stacks are only shown with 1 serial number.
I was able to do this with Report Writer,
Here's the SQL for it.
My caveat is that all my UnDP Serial pollers have Serial in the name. This way I didn't have to spell out every one.
SELECT
Nodes.Caption AS NodeName, Nodes.IP_Address AS IP_Address, CustomNodePollers_CustomPollers.UniqueName AS Poller_Name, CustomNodePollerStatus_CustomPollerStatus.Status AS Status
FROM
((Nodes INNER JOIN CustomPollerAssignment CustomNodePollerAssignment_CustomPollerAssignment ON (Nodes.NodeID = CustomNodePollerAssignment_CustomPollerAssignment.NodeID)) INNER JOIN CustomPollers CustomNodePollers_CustomPollers ON (CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerID = CustomNodePollers_CustomPollers.CustomPollerID)) INNER JOIN CustomPollerStatus CustomNodePollerStatus_CustomPollerStatus ON (CustomNodePollerAssignment_CustomPollerAssignment.CustomPollerAssignmentID = CustomNodePollerStatus_CustomPollerStatus.CustomPollerAssignmentID)
WHERE
(
(CustomNodePollers_CustomPollers.UniqueName LIKE '%serial%')
)
AND
(CustomNodePollerAssignment_CustomPollerAssignment.InterfaceID = 0)
Thanks!
