On our Router configs we have a SNMP Field "Chassis". We use this to add the Router Serial # and our Asset Tag # for tracking. Can I create a report that will pull this specific information off the routers?
Thank you
You can create a UnDP to pull the serial number using this OID-1.3.6.1.4.1.9.5.1.2.19 Then you'll have to write an Advanced SQL report to join the columns in each of the tables together to make your report.
Are you polling it using the UnDP in NPM or are you trying to create a report using NCM? I know you can do this using the NPM Report Writer if you use a UnDP to grab it. Otherwise you could try to write a custom SQL statement and use the Advanced SQL report in the writer.
So I haven't attempted to do this yet because I don't know where to start. Rather than spinning my wheels looking for a solution, I figured I would consult with the THWACK community to see if anyone knows how to do this. Forgive the possibly stupid question, what is UnDP?
UnDP = Universal Device Poller
NCM grabs this by default if I recall correctly so you might want to try to use the report writer built in to NCM.
If you don't have NCM, you'll have to create a UnDP and grab the Chassis serial and store it in NPM. Then use the Report Writer to create the report you seek.
Hope this helps.
Hey cfry.. i never saw an answer to your question.
Did you find resolution to this? I am looking for the exact same thing... a report within NPM that will allow me to import SNMP fields values/fields.
Any info would be appreciated.
Thanks,
LA
Larry,
Specifically what SNMP fields are you looking to grab?
Rob,
I'm trying to incorporate the serial number of my Cisco devices into a report I've built in NPM (report writer). The Cisco IOS command on all my C3560 and 3750 devices to retrieve this information is "Show snmp chassis".
