SCCM: SQL Reporting Services Custom Reports

  • Article

 

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.

 

-