Custom SQL query - ceAssetEntry per Cisco Device

Getting information with ceAssetEntry could be very useful.

I am having trouble though putting SQL query together especially when result is a table and I am interested only in one cell from that table.

Could somebody help me out on that?

Thank you.

Find more posts tagged with

Accepted answers

All comments

FormerMember

Can you elaborate? I don't understand the SQL query comment. Where are you querying SQL? If this is a MIB, you can use the Universal Device Poller.

lter

I am using SQL qury in Report righter.

For example here is query i use to get serial numbers from Cisco switches and VPN (altiga MIBS).

SELECT DISTINCT Nodes.Caption AS 'Node Name', Nodes.MachineType AS Machine_Type, Nodes.IP_Address AS IP_Address, Nodes.IOSImage AS IOS_Image, Nodes.IOSImage AS IOS_Image_1,

(SELECT CustomPollerStatus.Status

FROM CustomPollerStatus

INNER JOIN

CustomPollerAssignment

CustomPollerAssignment.CustomPollerAssignmentID = CustomPollerStatus.CustomPollerAssignmentID

WHERE

( CustomPollerAssignment_1.NodeID = CustomPollerAssignment.NodeID)

AND

(CustomPollerAssignment.PollerID = 'AB484A19-1367-4983-8AFB-8B7F2626CA8F')) AS 'Serial Number',

(SELECT CustomPollerStatus.Status

FROM CustomPollerStatus

INNER JOIN

CustomPollerAssignment

CustomPollerAssignment.CustomPollerAssignmentID = CustomPollerStatus.CustomPollerAssignmentID

WHERE

( CustomPollerAssignment_1.NodeID = CustomPollerAssignment.NodeID)

AND

(CustomPollerAssignment.PollerID = '79341729-E45C-4F62-BE3A-A632E007FFAC')) AS 'Serial Number2'

FROM CustomPollerAssignment AS CustomPollerAssignment_1

INNER JOIN

CustomPollers

CustomPollerAssignment_1.PollerID = CustomPollers.PollerID

INNER JOIN

Nodes

CustomPollerAssignment_1.NodeID = Nodes.NodeID

WHERE

(

(Nodes.Vendor = 'Cisco'))

)

You can see that particular MIB entry is working in the MIB Browser and then used it in SQL query. I found how to make it work forchassisSerialNumberString1.3.6.1.4.1.9.5.1.2.19 alHardwareSerialNumber1.3.6.1.4.1.3076.2.1.2.22.1.63

Both return just a string. So the sample I found sample in the forum and it did worked for the both of them.

Than I found

ceAssetSerialNumber

1.3.6.1.4.1.9.9.92.1.1.1.2

And verified that it is working in the MIB Browser. The only thing is it is returning a table or SNMPAdminString which looks like

Row ID Test Result

1 12345(serial number)

So It does not work the same way as for first two parameters.

You can email me and I will send you word file with more information.

My email address is lterebizh@gmail.com