cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
fdmarconi
Engaged Sweeper
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
1 ACCEPTED SOLUTION
crashff
Champion Sweeper
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

View solution in original post

2 REPLIES 2
fdmarconi
Engaged Sweeper
Excelent!

Many thanks!!
crashff
Champion Sweeper
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