So I am trying to create a report to quickly inventory all network (mainly cisco) devices that will report many predefined entries and also several custom entries, such as IOS bin file, system serial number, ram/flash etc.
I am able to get this running with one custom MIB, but my SQL falls a little short when trying to grab another.
I have no problems adding in and finding the MIBs that I want to use, I would appreciate if someone could lead me to the next step in adding another custompollerassignment to my report.
My current SQL reads:
-----------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT
Nodes.VendorIcon AS Vendor_Icon, Nodes.MachineType AS Machine_Type, Nodes.SysName AS System_Name, Nodes.IP_Address AS IP_Address, Nodes.IOSVersion AS IOS_Version, Nodes.IOSImage AS IOS_Image, Caption, CustomPollerStatus.Status, CustomPollerStatus.DateTime
FROM Nodes
LEFT JOIN CustomPollerAssignment ON Nodes.
NodeID = CustomPollerAssignment.NodeID
LEFT JOIN CustomPollerStatus ON CustomPollerAssignment.CustomPollerAssignmentID = CustomPollerStatus.CustomPollerAssignmentID
WHERE CustomPollerAssignment.AssignmentName like 'sysConfigName%'
ORDER BY 2 ASC
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Any help would be appreciated. Ideally I am trying to add 'entPhysicalSerialNum%' next.
Thank you.
