To Know the Collection Name based on Collection SCCM/ SMS ID

To Know the Collection Name based on Collection SCCM/ SMS ID

*******************

SELECT     CollectionID, CollID, Name, Comment, OwnedByThisSite, LastChangeTime, EvaluationStartTime, LastRefreshTime, RefreshType,
                      LastMemberChangeTime, MemberClassName, CurrentStatus
FROM         dbo.v_Collection
WHERE     (CollectionID = 'CollectionID')

**************

-------------------
Thanks,
http://sccm07.blogspot.com/