Share via

Report, showing all collections computer belongs to

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.