Count of all computer models:
select Model0, Count(*) from dbo.v_GS_COMPUTER_SYSTEM CS, dbo.v_FullCollectionMembership FCMWhere CS.ResourceId = FCM.ResourceId And CollectionID = 'SMS00001'Group by Model0
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment