I built a report that will take an inventory of all Cisco devices including SFP's, Power Supplies, Fans and Modules for the Cisco Contract. If you need it email me and I can send it out to you.
Which bit are you after?
Do you just mean getting the SQL/SWQL of the web report like you could do with report writer? If so the below will help.
"access the Orion server that hosts the web console and launch the Log Adjuster tool.
From Log Adjuster, enable all items related to Orion Hubble, click apply.
Then, launch the web report on its own browser tab/page.
You'll notice that there's a section that you can expand to see all the details from Orion Hubble.
From those details, you'll be able to see the SWQL used for generating the web report.
Copy the SWQL query and save it to notepad or somewhere.
Go back to Log Adjuster and disable any Orion Hubble stuff, hit apply."
Credit to ekis for the above, if it is what you're after.
Let me know either way
Ahh okay! Mmmm I don't think there is away without playing about with the Database however I'm sure I might be corrected.
You could also add the asset information to the main interface of each switch and the add in an extra field of the report linked above? Not the best way round it but its an idea. I will have a play an see if I can find an easy way
The only way I can see so far would be to add (up to) 9 new fields in the custom property editor, and add the asset tag for each individual switch in that stack, but that would be an ugly solution.
Might have found a way If you type in stack into reports you should see a Cisco one that has already been done by Solarwinds. In there, there is a field called Asset ID. One would assum that if you added an ID on the physical device under Asset ID it would display in that report... Or change the device description in the CLI
If that is what you're after here is how to report on the serial numbers
I have a feeling its NPM 12 and onwards only
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.