SCCM report to count hardware models

I needed an SCCM report to count how many of each type of hardware model we had in the environment. I created a new report with the following query:

GSCS.Manufacturer0 as [Manufacturer],
GSCS.Model0 as [Model],
count(*) as [Count]
from v_R_System RS
left join v_GS_COMPUTER_SYSTEM GSCS on RS.ResourceID = GSCS.ResourceID
Group by GSCS.Model0, GSCS.Manufacturer0
Order by GSCS.Model0