Video Screencast Help

Altiris Reporting-Do any SQL tables have information about BIOS version?

Created: 21 Jun 2013 | 3 comments

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

Operating Systems:

Comments 3 CommentsJump to latest comment

technical_specialist's picture

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

KNP's picture

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

consoleadmin's picture

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

collapse;width:283pt" width="377">
Release Date   Name  Bios Manufacturer  Bios Version 

Report

collapse;width:507pt" width="674">
Reports   Discovery and Inventory   Inventory   Cross platform Hardware   BIOS   Computers by BIOS DATE

Thanks.