Skip to main content

Collection Membership Viewer

image.png

The “Collection Membership Viewer” plugin displays all collections to which the selected client belongs. Additionally, individual collections can be refreshed, or the client can be removed from a direct membership.

Update membership

SCCM refreshes collection memberships at specific intervals.
This feature allows you to manually trigger the refresh.
This is only possible for Direct Rules (IsDirect).

Remove from collection

If this feature is enabled in the configuration, the client can be removed from a collection.
This is only possible for Direct Rules (IsDirect).

SCCM internal

The status indicator shows whether the respective collection is “SCCM-internal” ready or has been successfully processed.

Plugin configuration
Configuration Description Default value
AllowUpdateMembership Enables/disables the ability to trigger “Update Membership” operations False
DetailsQuery

SQL query to retrieve additional information about the collection.

For example: Description, Tag, IsTaskSequence

 
Click to view

 

SELECT DISTINCT
        cd.CollectionID                                   ,
        ISNULL(cd.Description, '')     AS 'Description'   ,
        ISNULL(cd.Tag, '')             AS 'Tag'           ,
        ISNULL(ss.[IsTaskSequence], 0) AS 'IsTaskSequence', (CASE WHEN (ss.[IsTaskSequence] IS NOT NULL) THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END) AS IsStandard
FROM
        [CollectionDescriptions] cd
LEFT JOIN
        [StandardSoftware] ss
ON
        cd.[CollectionID] = ss.CollectionID

UNION

SELECT DISTINCT
        ss.CollectionID                                   ,
        ISNULL(cd.Description, '')     AS 'Description'   ,
        ISNULL(cd.Tag, '')             AS 'Tag'           ,
        ISNULL(ss.[IsTaskSequence], 0) AS 'IsTaskSequence',
        CAST(1 AS BIT)                 AS IsStandard
FROM
        [StandardSoftware] ss
LEFT JOIN
        [CollectionDescriptions] cd
ON
        cd.[CollectionID] = ss.[CollectionID]
Query SQL query to determine collection memberships
Click to view 
SELECT
        vc.CollectionID AS 'CollectionID' ,
        vc.Name         AS 'Name'         ,
        vc.Comment      AS 'Comment'      ,
        fcm.Name        AS 'ComputerName' ,
        fcm.ResourceID                    ,
        fcm.IsDirect AS 'IsDirect'
FROM
        v_FullCollectionMembership fcm
LEFT JOIN
        v_Collection vc
ON
        fcm.CollectionID = vc.CollectionID
WHERE
        fcm.ResourceID = {RESOURCEID}
ORDER BY
        vc.Name
StateCheckQuery

SQL query to check the assignment status of a computer object to a collection. The “CheckValue” column must be returned. If the query returns a result, a green traffic light icon is displayed in the graphical interface; otherwise, a yellow icon is displayed. The query supports various replacement parameters:

    • {COLLECTIONID}: Replaces the ID of the currently selected collection.
    • {ResourceID}: Replaces the ID of the currently selected computer object.
Click to view

 

SELECT
        col.Name AS CheckValue
FROM
        v_R_System AS vcrd
LEFT OUTER JOIN
        _RES_COLL_{COLLECTIONID} AS col
ON
        col.MachineID = vcrd.ResourceID
WHERE
        vcrd.ResourceID = {ResourceID}
Default Plugin Integration
  • Assembly: CollectionMemberShipViewerPlugin
  • Name: COLLECTION_MEMBERSHIP_VIEWER (to be translated)
  • Icon: elements_view.png
Supported Functions:
  • ALLOW_REMOVE_FROM_COLLECTION: When this option is selected, the context menu will include an entry to remove the selected computer object from the respective collection.

Back to top