Wednesday, January 14, 2009

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/

No comments: