Cacher is the code snippet organizer for pro developers

SELECT
       [Chassis Type] = [vac1].[Chassis Type]
       , [Model] = [vhw1].[Model]
       , [Count] = COUNT(1)
FROM
    [vComputer] [vc1]
    join [vAC_ChassisType] [vac1] on [vc1].[Guid] = [vac1].[Guid]
       join [vHWComputerSystem] [vhw1] on [vc1].[Guid] = [vhw1].[_ResourceGuid]
WHERE
       [vac1].[Chassis Type] NOT IN ('desktop','laptop','server','virtual')
GROUP BY
       [vac1].[Chassis Type]
       , [vhw1].[Model]
ORDER BY
       [vac1].[Chassis Type]
       , [vhw1].[Model]