Unable to find Serial Number BIOS data class in Inventory Solution 7

[jjesse]

In Inventory 6 there is a data class called Inv_AeX_HW_Serial_Number that contains the following: System Manufacturer, Computer Model, Serial Number, System Model Number, Asset Tag, Source, Agent Version, Computer Type, UUID.

In CMS 7 I cannot find this data class.  The data class is there but shows up under the 6.x Data class and is not being populated by Inventory.

I do have Hardware Inventory enabled and am returning hardware information.

Seems silly that I would have to write a custom inventory to return Serial Number out of the BIOS.

Any help?

[KSchroeder]

jjesse,
It seems they Serial Number is accessible via a view.  The following from the "Computers by Serial Number" report:

SELECT DISTINCT     
    i.[Guid],
i.[Name],  
i.[Domain],      
s.[Identifying Number] [Serial Number]          
FROM dbo.vComputer i

JOIN dbo.vHWComputerSystem  s 
  ON s.[_ResourceGuid] = i.[Guid]      

JOIN dbo.CollectionMembership cm 
ON i.[Guid] = cm.ResourceGuid 
JOIN dbo.vCollection it 
ON it.Guid = cm.CollectionGuid 
WHERE s.[Identifying Number] <> 'Not Found'     
AND s.[Identifying Number] <> 'No Asset Tag'     
AND s.[Identifying Number] <> 'not yet supported'   
AND LOWER (s.[Identifying Number]) LIKE LOWER ('%Serial Number%')   
AND LOWER (i.[Name]) LIKE LOWER ('%ComputerName%')   
AND i.[Domain] LIKE '%Domain%'  
AND lower (it.[Guid]) LIKE lower ('%Filter%')   
ORDER By i.[Name]

  vHWComputerSystem in turn pulls its serial number (or rather [Identifying Number]), from the table

 

Inv_HW_Computer_System

  .[Identifying Number].  There is also a [Serial Number] column in the Inv_HW_Baseboard table.

[KSchroeder]

Clearly, alot of our custom reports are going to have to be re-written...or the legacy tables will need to be reconstructed as Views against the new Inventory schema (and frankly I'm surprised that they aren't already).

[Migration User]

How about trying the Inv_HW_Chassis table?  There's also the "Identifying Number" column in Inv_HW_Computer_System.

[Pascal KOTTE]

Hi, after running a full inventory, I got those information exactly the 2 places you give above, thanks Mitch.
It seems I was not having those running standard "standalone" inventory :-(
I test on a Dell laptop.