Unable to find Serial Number BIOS data class in Inventory Solution 7
Updated: 21 May 2010 | 4 comments
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?
discussion Filed Under:
Comments
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
For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.
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
For Forum threads, please click "Mark as Solution" if answered.
For all content, please give a thumbs up if you agree with or support the post.
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.
~Pascal @ Bechtle~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF&l
Would you like to reply?
Login or Register to post your comment.