[Dell BIOS Version Report]

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

[Find computers with Office 2003 installed]

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.