skw

Pulled the following SQL statement directly from Dell's website. It shows me a total count of machines based on the BIOS version. Trying to figure out how to create a drill-down report or create a new report to show me the actual machine names and their BIOS version. It's nice to know that I have 5 machines that are Latitude D820's with BIOS A05, but which machines have A05? SELECT CompSys.Manufacturer0 as 'OEM', CompSys.model0 as 'Model',BIOS.SMBIOSBIOSVERSION0 as 'BIOSVersion', COUNT(Sys.Resourceid) AS 'TotalSystems' 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 WHERE CompSys.Manufacturer0 LIKE '%dell%' AND (CompSys.Model0 LIKE '%optiplex%' OR CompSys.Model0 LIKE '%latitude%' OR CompSys.Model0 LIKE '%precision%') GROUP BY CompSys.Manufacturer0,CompSys.model0, BIOS.SMBIOSBIOSVersion0 ORDER BY CompSys.Model0, BIOS.SMBIOSBIOSVersion0

I am deploying a Microsoft Office Professional volume license and need to know how to make a collection to find computers that have Office 2003 (Basic, SB, and Pro) installed.