→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kevinoie
Engaged Sweeper III
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.
1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Daniel_B
Lansweeper Alumni
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