Day: November 2, 2016

SELECT CompName.Name0 as ‘Computer Name’, CompSys.Manufacturer0 as ‘OEM’, CompSys.model0 as ‘Model’, BIOS.SMBIOSBIOSVERSION0 as ‘BIOSVersion’, BIOS.ReleaseDate0 as ‘Release Date’ FROM V_R_System as Sys LEFT JOIN V_GS_PC_BIOS as BIOS on Sys.resourceid = BIOS.resourceid LEFT JOIN V_GS_COMPUTER_SYSTEM as CompSys on Sys.resourceid = CompSys.resourceid LEFT JOIN V_GS_SYSTEM as CompName on Sys.resourceid = CompName.resourceid GROUP BY CompSys.Manufacturer0,CompSys.model0, BIOS.SMBIOSBIOSVersion0, CompName.Name0, BIOS.ReleaseDate0…