Service Tag data in SolarWinds Platform database

10/29/2018 1:00 PM

10/16/2025 6:01 PM

Service Tag information is frequently requested by customers so that they can add it to reports that are not created through SolarWinds.  This article addresses the tables (views) that store Service Tag data.

Orion Platform

Service Tag information can be found in the following tables:

 

AssetInventory_ServerInformation: The column HardwareSerialNumber contains the Service Tag. This table also contains the host and system names, so it isn't necessary to get the node name from the Nodes view.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT siv.NodeID, n.Caption, n.IP_Address, siv.Manufacturer, siv.Model, siv.HardwareSerialNumber
FROM [dbo].[AssetInventory_ServerInformationView] siv
INNER JOIN  Nodes n ON siv.NodeID = n.NodeID
WHERE siv.HardwareSerialNumber is not NULL
ORDER BY siv.SystemName

 

APM_HardwareInfo:  The column ServiceTag, contains the Service Tag.  This view does NOT contain the node name.  Hence one would have to join the contents of this table with the Nodes view to get the node name.

-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.

SELECT n.Caption, n.IP_Address, hi.NodeID, hi.Manufacturer, hi.Model, hi.ServiceTag FROM [dbo].[APM_HardwareInfo] hi
INNER JOIN Nodes n ON hi.NodeID = n.NodeID
WHERE hi.ServiceTag is not NULL
ORDER BY n.Caption