publicrelop.blogg.se

Where tblBIOS.SMBIOSBIOSVersion Bios.biosMax And tblAssetCustom.State = 1 Inner Join tsysOS On tsysOS.OScode = tblAssets_1.OScode TblAssetCustom.Manufacturer = Bios.Manufacturer And TblAssetCustom_1.Model) As Bios On tblAssetCustom.Model = Bios.Model And TblAssetCustom_1.Model Not Like 'Virtual Machine' TblAssetCustom_1.Model Not Like 'VMware Virtual Platform' And Where tblAssetCustom_1.Model Not Like 'VirtualBox' And Inner Join tblBIOS As tblBIOS_1 On tblAssets.AssetID = tblBIOS_1.AssetID Inner Join tblAssetCustom As tblAssetCustom_1 On tblAssets.AssetID =

Max(tblBIOS_1.SMBIOSBIOSVersion) As biosMax Inner Join (Select tblAssetCustom_1.Manufacturer, Inner Join tblAssetCustom On tblAssets_1.AssetID = tblAssetCustom.AssetID

Inner Join tblBIOS On tblAssets_1.AssetID = tblBIOS.AssetID TblBIOS.SMBIOSBIOSVersion As CurrentBios,Ĭase When tblBIOS.SMBIOSBIOSVersion = Bios.biosMax Then 'black' Else 'red'