select Model0, Count(*) from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_FullCollectionMembership FCMWhere CS.ResourceId = FCM.ResourceId And CollectionID = 'SMS00001'Group by Model0