Hi All,
I am looking for an answer that is relating to thread below which unfortunately is still unanswered.
https://thwack.solarwinds.com/product-forums/network-configuration-manager-ncm/f/forum/39904/rest-api-query-node-serial-number-or-uuid
Hope it will be answered now.
kt617 did you manage to find any working solution
Its a little hard to know how to answer this, you haven't told us exactly what you are trying to do, and what you have tried. I promise that better answers come when you can give the forum more.
There are a number of discussions about pulling data from SolarWinds into a CMDB, that thread was about using ServiceNow. Since I don't know where you are putting it, let me just point out the supported connector to Service now CMDB: ServiceNow Store If you have the right license, its a great method.
Next, the API is queried via SWQL, so any of shared queries in the Content Exchange on Thwack will work, like: Asset Inventory: Network Devices (from NCM) - Custom Queries - The Orion Platform - THWACK (solarwinds.com) (since you posted in NCM this might be the information you want) Asset Inventory: Network Interfaces - Custom Queries - The Orion Platform - THWACK (solarwinds.com) Asset Inventory: Linux Servers - Custom Queries - The Orion Platform - THWACK (solarwinds.com) Asset Inventory: Windows Server - Custom Queries - The Orion Platform - THWACK (solarwinds.com)
But if you don't see what you want, you can absolutely find it, I recommend using SWQL Studio in the SDK.
github.com/.../OrionSDK
You can even search the views, below I searched for SerialNumber and references that are available in SWQL are shown.
If you aren't familiar with pulling data in this way, there are links to resources through out thwack and videos on the Soalrwinds YOutube that walk you through SWQL and the SDK, but the SDK has samples, and a second SDK for Python. SWQL studio will even helpget started
It pulls a default view query:
And you can take it out of SWQL studio with a copy of sample queries straight to the API.
We use IP Address as the key between Solarwinds and SNow. it works 99 percent of the time but we are doing a data pull from SNow into Solarwinds, not the other direction. We do also use the SNow Connector.
To add on to @JM_sysadminstatement, depending on the device type, the serial number OID may be different. In the case of some of our UPS units the MIB for those were not in the Solarwinds MIB Database and we had several models with several different OID's for that value. To get around that we created a Custom Property called Serial Number and use an alert action Change Custom Property to populate it.
In doing that we can get a single field to contain data from several different custom pollers in one place.
You would need to place the SWQL that JM_sysadmin referenced to grab that data and populate the field.
This probably only applies to nodes that Solarwinds doesn't manage out of the box, but that is how I got all of our custom pollers for serial numbers into one place so I could create reports on them.
