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.

 


Comments (0)

Skip to main content