Report, showing all collections computer belongs to

  • Article

Here is an SCCM report, that takes computer name and shows all collections that computer belongs to

Query used in this report:

select

C.Name0, B.CollectionID,B.Name from v_ClientCollectionMembers A,

v_Collection B

,

v_R_System C

where

A.CollectionID=B.CollectionID

and

A.ResourceID = C.ResourceID

and

C.Name0= @Name

 

All Collections, Computer Belongs to.MOF

Comments

  • Anonymous
    January 14, 2010
    Why don't you just use the view v_FullCollectionMembership (joined to v_R_System)?
  • Anonymous
    January 18, 2010
    OK, I found v_ClientCollectionMembers first.
  • Anonymous
    January 20, 2011
    Thanks, exactly what the doctor ordered.