List Computers by Manufacturer and Model

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