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.

Release Date   Name  Bios Manufacturer  Bios Version 

Report

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

 

Thanks.