SCCM: SQL Reporting Services Custom Reports
Report: List Computers by Manufacturer and Model
SELECT SYS.Netbios_Name0, SYS.User_Name0, CSYS.Manufacturer0, CSYS.Model0
FROM v_R_System SYS
RIGHT JOIN v_GS_COMPUTER_SYSTEM CSYS on SYS.ResourceID = CSYS.ResourceID
ORDER BY CSYS.Manufacturer0, CSYS.Model0, SYS.Netbios_Name0
NOTE: This query only displays machines that are reporting Manufacturer and Model by using the RIGHT JOIN.
-