SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

Count of Models by Collection

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

Published Feb 16 2009, 09:54 PM by Garth
Filed under: , , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems