I was asked by my Project Manager to generate a report for HP machines (desktop and laptops) that lists Hosts names, Hardware Model, BIOS version and Operating System version. I Run the Query below SQL Management Studio and saved the result to a CSV file:

SELECT

Bios.SerialNumber0 as [Serial Number],
Bios.SMBIOSBIOSVersion0 as [BIOS Version],
Comp.Name0 as [Machine Name],
Comp.Manufacturer0 as [Manufacturer],
Comp.Model0 as [Model],
Ops.Caption0 as [Operating System]

FROM
v_GS_COMPUTER_SYSTEM comp join
v_GS_OPERATING_SYSTEM ops on ops.ResourceID=comp.ResourceID join
v_GS_PC_BIOS bios on bios.ResourceID=comp.ResourceID

WHERE
(Comp.Manufacturer0 LIKE ‘%HP%’OR comp.Manufacturer0 LIKE ‘%Hewlett-Packard%’) AND comp.model0 NOT like ‘%ProLiant%’

ORDER BY Comp.Name0, Comp.Manufacturer0, Comp.Model0, Bios.SerialNumber0, Bios.SMBIOSBIOSVersion0, Ops.Caption0

Result