Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

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

Updated: 21 May 2010 | 4 comments
jjesse's picture
+1 1 Vote
Login to vote

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?

Comments

KSchroeder's picture
11
Sep
2009
0 Votes 0
Login to vote

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]

  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.

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.

KSchroeder's picture
11
Sep
2009
0 Votes 0
Login to vote

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.

MitchInOmaha's picture
23
Sep
2009
0 Votes 0
Login to vote

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.

Pascal.KOTTE at BECHTLE's picture
20
Oct
2009
0 Votes 0
Login to vote

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