There are two types of Collection Views in SCCM.

  • Collection Membership Views
  • Collection Property Views

Collection View

Description

v_ClientCollectionMembersLists all devices, by resource ID, that are not in an obsolete or decommissioned state, what collections the device is a member of, and whether the resource is a Configuration Manager client.

The view can be joined to other views by using the CollectionID and ResourceID columns.

v_CM_RES_COLL_<CollectionID>Lists all devices that are members of the collection. The device ID, name, client GUID, site code, whether the computer is assigned to a site, whether the computer has been approved, whether the computer is an active client, and so on.

The view can be joined to other views by using the CollectionID and ResourceID columns.

v_CollectionLists all collections by collection ID, collection name, and what view the collection maps to (listed in the v_CM_RES_COLL_<CollectionID> row), the last time the collection membership changed, as well as other collection information.

The view can be joined to other views by using the CollectionID column.

v_CollectionRuleDirectLists the collections that contain direct membership rules.

The view can be joined to other views by using the CollectionID or ResourceID columns.

v_CollectionRuleQueryLists the query statement for each query-based collection.

The view can be joined to other views by using the CollectionID and LimitToCollectionID columns.

v_CollectionSettingsLists the configured settings for each collection, such as restart countdown, polling interval, collection variable precedence, source site, last modification time, and more.

The view can be joined to other views by using the CollectionID column.

v_CollectionVariableLists the collections that have associated task sequence variables.

The view can be joined to other views by using the CollectionID column.

v_FullCollectionMembershipLists the resources for all collections. Contains the collection ID, resource ID, name, domain, resource GUID, site code, and other client information.

The view can be joined to other views by using the CollectionID and ResourceID columns.

v_FullCollectionMembership_ValidLists the resources that are not in an obsolete or decommissioned state for all collections and contains a subset of information from the v_FullCollectionMembership view.

The view can be joined to other views by using the CollectionID and ResourceID columns.

v_ServiceWindowLists all collections that have a configured maintenance window and information about the maintenance window, such as the maintenance window name, description, start time, and duration.

The view can be joined to other views by using the CollectionID column.

v_CollectionsLists all collections by collection ID and collection name. Also contains further information about each collection, for example:

  • The last time the collection was changed (LastChangeTime)
  • The last time the collection was re-evaluated (LastRefreshRequest)
  • The collections limiting collection (LimitToCollectionID)
  • Whether the collection is built-in, or was created by an administrator (IsBuiltIn)

The view can be joined to other views by using the CollectionID column.

Source – https://docs.microsoft.com/en-us/previous-versions/system-center/system-center-2012-R2/dn581985(v%3dtechnet.10)

Close Menu

Sorry, but I had to.

I use cookies and similar technologies to run this website to help me understand how you use it. Privacy Policy