Bios Release Report

[kevinoie]

Hi. I am trying to run a full HW report to include the BIOS release date. When I run the below report, I get all details of pc's and servers on the network.

Select Top 1000000 tblAssets.AssetName,
tblADusers.Name,
tblADusers.Description,
tblADusers.Office,
tblAssets.IPAddress,
tblOperatingsystem.Caption,
tblAssets.Memory,
tblAssets.Processor,
tblAssets.NrProcessors,
tblSystemEnclosure.Manufacturer,
tblAssetCustom.Model,
TsysChassisTypes.ChassisName
From tblADusers
Inner Join tblAssets On tblAssets.Username = tblADusers.Username
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblSystemEnclosure
On tblAssets.AssetID = tblSystemEnclosure.AssetID
Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
TsysChassisTypes.Chassistype
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID


However, When I add the TblBios table, and select release date, the report comes up with no records. Cant see what im doing wrong so any help is appreciated. Kevin.

[Daniel_B · Accepted solution]

tblBIOS needs to be joined to tblAssets. We recommend that you right-click on the connection between tblAssets and tblBIOS and "Select all rows from tblAssets". BIOS information is only scanned from computers with Windows Vista, Windows Server 2003 or higher.

Select Top 1000000 tblAssets.AssetName,
  tblADusers.Name,
  tblADusers.Description,
  tblADusers.Office,
  tblAssets.IPAddress,
  tblOperatingsystem.Caption,
  tblAssets.Memory,
  tblAssets.Processor,
  tblAssets.NrProcessors,
  tblSystemEnclosure.Manufacturer,
  tblAssetCustom.Model,
  TsysChassisTypes.ChassisName,
  tblBIOS.ReleaseDate As [BIOS release date]
From tblADusers
  Inner Join tblAssets On tblAssets.Username = tblADusers.Username
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblSystemEnclosure
    On tblAssets.AssetID = tblSystemEnclosure.AssetID
  Inner Join TsysChassisTypes On tblSystemEnclosure.ChassisTypes =
    TsysChassisTypes.Chassistype
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID