SMSUG.ca

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

Garth Jones

List Collections a PC belongs to

select
FCM.CollectionId,
C.Name
from
dbo.v_R_System r
join dbo.v_FullCollectionMembership FCM on R.ResourceID = FCM.ResourceID
join dbo.v_Collection C on C.CollectionID = FCM.CollectionID
Where
R.Name0 = 'ES-03'

Comments

No Comments

This Blog

Syndication

News

Training

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