Client Management Suite

I have combed through Resource Manager and through the tables and cannot find anything that has a clear Dell BIOS version like A14.  The closest I found was INV_SW_BIOS_ELEMENT, but it has crazy values in it.  Does anyone know if I can query the BIOS versions of my computers through Altiris?

Thanks,

Dan

Check the Forum

http://www.symantec.com/connect/forums/sql-queryreport#comment-8493101

Report location from Altiris

Reports  --> Discovery and Inventory  --> Inventory  --> Cross-platform  --> Hardware  --> BIOS  --> Computers by BIOS DATE

Hi Drheim,

Try below Query.

SELECT dbo.Inv_AeX_AC_Identification.[Name][Host Name]
, dbo.Inv_AeX_AC_Identification.[Os Name]
, dbo.Inv_AeX_AC_Identification.[System Type]
, dbo.Inv_AeX_AC_Identification.[Last Logon User]
, dbo.Inv_AeX_AC_TCPIP.[MAC Address]
, dbo.Inv_AeX_AC_TCPIP.[IP Address]
, dbo.Inv_SW_BIOS_Element.[Version][BIOS Version]

FROM
dbo.Inv_AeX_AC_Identification,
dbo.Inv_AeX_AC_TCPIP,
dbo.Inv_SW_BIOS_Element

WHERE
dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_AeX_AC_TCPIP._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_SW_BIOS_Element._ResourceGuid

Inbuilt report is already availble in Altiris Server. Which can added the below column.

Report