Are you referring to the Service Tag information shown in SAM's Asset Inventory? If so, the table is AssetInventory_ServerInformation, and the column name is HardwareSerialNumber. Any reason why you are querying the DB directly?
Thanks, that has the server serials I was looking for. Do you know where the network devices (routers, switches, etc) would be stored?
We're directly querying the DB to propagate a new asset management database. Since most of this equipment is already in SolarWinds we can save a lot of time by just using that information rather than manually entering it all into the new system.
Most databases have some sort of import function from a speadsheet. It is probably quicker for you to export the data to excel from the reports, and import into your database.
for NCM, no easy way to query the tables as far as I know. but you can definitely export them to CSV
p.s: please mark the discussion as answered and move it to the SAM forum
After the initial transfer of information from SolarWinds to the asset management system there will be either nightly or weekly dumps from SW to the asset DB. The process will then add any new device information from SW to the asset DB. This will be a scheduled process with no human intervention. We have all of the necessary table and column names found in the SW SQL DB except for the network device serial numbers. The serial information shows up as "Service Tag" in the Hardware Details section of the device on the web interface. I just can't seem to find where this is stored in the SQL DB.
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.