Here is a query query for count of computer Models.
;with m as (
CS.Manufacturer0 as ‘Manufacturer’,
When ‘LENOVO’ then CSP.Version0
end as ‘Model’
join dbo.v_GS_COMPUTER_SYSTEM CS on RV.ResourceID = CS.ResourceID
join dbo.v_GS_COMPUTER_SYSTEM_PRODUCT CSP on RV.ResourceID = CSP.ResourceID)
Count(*) as ‘total’