![]() 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'
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |