I saw a thread located here: https://thwack.solarwinds.com/product-forums/network-performance-monitor-npm/f/forum/41638/need-help-identifying-database-table-location-for-hardware-field
asking the question - where's the database table for hardware info? A lot of the answers focused on doing the reverse and working with the Virtual Machine to rule out items that you knew were hardware, but they still didn't reveal hardware stats - these tables allow for that.
Check out AssetInventory_tableName
I recently needed to get Model info for all of my machines and used this query:
SELECT s.NodeID, s.SystemName, s.OperatingSystem, s.Model FROM AssetInventory_ServerInformation s
where s.Model <> 'Virtual Machine'
