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')
**************