cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

SQL Table and column name for Service Tag field

Jump to solution

Where in the SolarWinds database is the service tag for a device stored? I've gone through what seems like every single table in the DB and cannot find this.

0 Kudos
1 Solution

It is located in the column ServiceTag of the APM_HarwareInfo.

View solution in original post

0 Kudos
5 Replies
Level 17

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.

0 Kudos
Level 17

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

0 Kudos

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.

0 Kudos

It is located in the column ServiceTag of the APM_HarwareInfo.

View solution in original post

0 Kudos