Custom report to pull power supply SN's from Cisco Devices

[jpalmer]

We're working on trying to get a list of the PSU SN's from our Cisco devices, and we want to see if reporting can pull this info from the devices.

Does anyone know if this can be done/has been done before?  I've already got a good report for the chassis PSU, but trying to get one for the PSU Sn's

specifically, looking to do this to the 2960x series. 

[nathan.hejnicki]

Is the data for the PSU's available via Universal Device Pollers? If it is, you can set those pollers up and set them to only poll like once an hour or even less since the SN rarely if ever changes. Once you have the UnDP set up you can add it to a report or a Node Details view with relatively simple queries, provided the UnDPs are able to poll the OIDs for that info.

Let me know how the process goes or if there's anything I can do to help.

Nathan Hejnicki

Loop1

[jpalmer]

Hey Nathan!

Actually yes it is;  After your post, I went in (and taught myself along with some great help docs) about building a custom UnDP poller.  I have the poller working, and I can see the info on the device status pages for the ones I specified it for.   However, I'm having problem locating where the UnDP poller is located, so I can add it into a custom report.

[lynchnigel]

if from the report you hit edit which is next to the 'from ----device--  with edit at the side of it

you can select it from in there where it says select field

[jpalmer]

I'm trying to find how to add this, but I cannot locate the custom UnDP poller I created is located in the options here... it doesn't seem to be listed anywhere.

[lynchnigel]

is this what you are doing? Searching for the unique name?

[jpalmer]

Actually what I'm trying to do (if possible) is take this new data and add it into a report table, like this:

I have the dynamic query builder set to screen out for certain criteria already:

What I want, if it's possible, is to add this custom field into the top table layout, so it will display the PSU serial numbers along with the output from the rest of the report (which does work perfectly).

[lynchnigel]

indeed and then

[mesverrum]

So the problem is that the report building needs you to specify the most specific object as the type of object you want to report on.  If you pick custom undp poller then you will also have access to all the properties of the parent node, but if you start at a node report you can't get into the more granular stuff.  This limitation mostly just has to do with the way sql deals with the table joins as doing it any other way tends to make the reports insane with duplicate rows.

Anyway do like the above example, make the object a custom node poller and then you just select those same columns you already had for caption ip etc.