Report of bios age, name of computer in active directory and brand and model HW

[fdmarconi]

Hi!

I need help for create a report including the report of bios age, the name of the computer in active directory and brand and model of the HW.

somebody can i help me please?

Many Thanks!!

Regards.
Federico

[fdmarconi]

Excelent!

Many thanks!!

[crashff · Accepted solution]

See if this works for you:

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.FQDN,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Serialnumber,
  tblBIOS.SMBIOSBIOSVersion,
  tblBIOS.ReleaseDate
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblBIOS On tblAssets.AssetID = tblBIOS.AssetID
Where tblAssetCustom.State = 1