This query was developed from a WQL query posted in the myITforum forums. It was "translated" from the format and tables used in SMS queries to the SQL code needed for SMS reports.
SELECT distinct SYS.Netbios_Name0 as "Computer Name", CSYS.Model0 as "Computer Model", opsys.CAPTION0 as "Operating System", BIO.name0 as "BIOS Maker"
FROM v_R_System SYS
JOIN v_GS_PC_BIOS AS BIO ON BIO.ResourceID = SYS.ResourceID
LEFT JOIN v_GS_COMPUTER_SYSTEM CSYS on SYS.ResourceID = CSYS.ResourceID
LEFT JOIN v_GS_OPERATING_SYSTEM OPSYS on SYS.ResourceID=OPSYS.ResourceID
WHERE SYS.Netbios_Name0 is not null
ORDER BY SYS.Netbios_Name0