Unable to find Serial Number BIOS data class in Inventory Solution 7
jjesse
September 10th, 2009
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?
jjesse, It seems they Serial
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]
Inv_HW_Computer_System
.[Identifying Number]. There is also a [Serial Number] column in the Inv_HW_Baseboard table.
Thanks,
Kyle
Symantec Trusted Advisor
If your question has been resolved, please be sure to click "Mark as Solution"! Thank you.
Clearly, alot of our custom
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).
Thanks,
Kyle
Symantec Trusted Advisor
If your question has been resolved, please be sure to click "Mark as Solution"! Thank you.
How about trying the
How about trying the Inv_HW_Chassis table? There's also the "Identifying Number" column in Inv_HW_Computer_System.
-- Mitch
If your question has been resolved, please be sure to "Mark as Solution"! Thank you.
Yep - your are right
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.
~~PaKo @ www.BeMore.ch (Sorry for the Bad English, did you speak French ? Join us https://www-secure.symantec.com/connect/groups/gro... )
Would you like to reply?
Login or Register to post your comment.