Supplement the HardwareSerialNumber

I am new to ORION but am good with SQL; and I recently learned how to make a custom monitor under SAM.

What would I do if I want to poll and store a value?

I want to get the bios serial from computers in SW, easy using PowerShell. There is a field in the DB for HardwareSerialNumber but it's not populated on a lot of systems.

EDIT1: Similar to this question that is unanswered for 1 year.
EDIT2: Adding a bit of background for color: I'm looking for a way to reliably obtain system hardware (physical AND virtual) serial numbers for the purpose of uniquely identifying a device for deduplication when combining the inventory from SW with the inventory of another platform.

Find more posts tagged with

bios

serial number

PowerShell

Accepted answers

All comments

KMSigma.SWI

You should already get the serial number from the Asset Inventory feature. [Example]

It may not be stored in the table you think it should be using, but it is captured.

tonypags

Hi,
Thanks for replying. In your example the demo device has a serial number listed in the WebUI. I have many servers that don't have this field populated.

What I found was that not all devices have a serial number, including all of our VMWare VMs. I was using the SWQL Studio to locate the data.

Orion.AssetInventory.NodeWarrantyAlert
Orion.AssetInventory.ServerInformation

If you know of another table that has this info, would you be able to share it? It would help me a lot.

KMSigma.SWI

Depending on the products you have installed, it could be in NCM (Cirrus) tables or possibly the Node Details tables, but the two above (Asset Inventory) are my go-to places for this kind of information.

tonypags

Not found. I confirmed this in your demo env by finding a VMWare guest server and looking for the serial. Same issue: None.

My original question stands: Can I somehow supplement the existing table with a poll using custom WMI command?

If not, is there a standard way the ORION RMM uses to poll data for inventory purposes (not monitoring/alerting) and store it for reporting?

Seashore

If you are monitoring vmware from Orion you will have a lot of info about all virtual machines, including a value called [UUID]. That value seems to be the same as what you get if you run "wmic bios get serialnumber". A bit different formatting but the value is the same.

tonypags

Hi,

This is useful and it got me what I needed, this time. Thanks.

However my original, big, bold question still hasn't been answered: What would I do if I want to poll and store a value?

Is it impossible?

stevenstadel

You can create a custom SAM component monitor using PowerShell to grab whatever you like. The syntax (like Serial) will go into the Message portion of the polled result. This is a well documented example File & Folder Details (PowerShell) - Application Monitor Templates - Server & Application Monitor - THWACK (solarwinds.com).

KMSigma.SWI

It's not impossible it it's being caught in your database. If you are monitoring the ESX host (or vSphere), you might already be capturing it - though it won't be in the same set of entities.

If you have SWQL Studio, run this and let us know if you get anything back.

SELECT [VMs].UUID
     , [VMs].GuestDnsName
     , [VMs].DisplayName
FROM Orion.VIM.VirtualMachines AS [VMs]

If so, then we can look for a way to connect the two data sets to give you one cohesive report of the data.

tonypags

You mentioned I need to create a monitor, but that's not what I'm asking. I specifically asked to poll and store a value. It doesn't make any sense to "monitor" the serial number of a computer. Think about it. Am I mistaken?

tonypags

Hi, Yes this gives me results I can join into my table, which I have already done.

    SELECT i.NodeID
        ,CASE
            WHEN n.DNS IS NULL THEN n.Caption
            WHEN n.DNS = '' THEN n.Caption
            ELSE n.DNS
            END AS Hostname
        ,i.Name AS Adapter
        ,i.IPAddress
        ,i.MACAddress
        ,i.Manufacturer
        ,i.Gateway
        ,i.DHCPServer
        ,i.Netmask
        ,i.DNSServers
        ,i.Alias
        ,n.Description
        ,n.SysName
        ,v.UUID
        ,s.HardwareSerialNumber
        ,n.LastBoot
        ,n.SystemUpTime
        ,n.LastSync
        ,n.BlockUntil
        ,n.MinutesSinceLastSync
        ,n.DetailsUrl
        ,n.DisplayName
    FROM Orion.AssetInventory.NetworkInterface i
        JOIN Orion.Nodes n 
            ON i.NodeID=n.NodeID
            AND n.EntityType = 'Orion.Nodes'
            AND n.IsServer = TRUE
        LEFT JOIN Orion.AssetInventory.ServerInformation s
            ON n.NodeID=s.NodeID
        LEFT JOIN Orion.VIM.VirtualMachines v
            ON n.NodeID=v.NodeID
WHERE v.UUID IS NULL
AND (
       s.HardwareSerialNumber = 'none' 
    OR s.HardwareSerialNumber IS NULL
)

I've added a WHERE clause at the end to showcase the problem with missing items. Spot checking these I found a mix of 1) offline or WMI corrupted devices, and 2) ones that are online and have WMI returning a value.

In the latter group, of these, I've only found VMs that don't have a UUID stored in SWIS. Any advice on how to dig into those missing values?