Collection views contain information about the collections, collection rules, and collection members. Many of the collection views are useful when creating reports on system data, software update deployments, software distribution advertisements, and desired configuration management configuration items.
Following are the two types of collection views:
- The first type lists all members of a specific collection and
starts with the v_CM_RES_COLL_ view name and ends with the
collection ID, with the exception of the v_FullCollectionMembership
view, which lists all members of all collections. This collection
type will be used most often when creating reports.
- The second type of collection view has a name that starts with
v_ and contains general information about the collections but not
the member resources within each collection.
The collection views are described in the following table.
| Collection View | Description |
|---|---|
|
v_ClientCollectionMembers |
Lists all system resources, by resource ID, that are not in an obsolete or decommissioned state, what collections the system resource 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 client computers that are members of the collection. The machine 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 ResourceID column. |
|
v_Collection |
Lists 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_CollectionRuleDirect |
Lists the resources in collections that have direct member rules. The view can be joined to other views by using the CollectionID or ResourceID columns. |
|
v_CollectionRuleQuery |
Lists the query for each query-based collection. The view can be joined to other views by using the CollectionID and LimitToCollectionID columns. |
|
v_CollectionSettings |
Lists the configured settings for each collection, such as reboot countdown, polling interval, collection variable precedence, source site, last modification time, and so on. The view can be joined to other views by using the CollectionID column. |
|
v_CollectionVariable |
Lists the collections that have associated task sequence variables. The view can be joined to other views by using the CollectionID column. |
|
v_CollectToSubCollect |
Lists subcollections and the associated parent collection. The view can be joined to other collection views by using the parentCollectionID or subCollectionID columns. |
|
v_FullCollectionMembership |
Lists 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_Valid |
Lists 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_ServiceWindow |
Lists the collections that have an associated maintenance window and information about the maintenance window, such as maintenance window name, description, start time, and duration. The view can be joined to other views by using the CollectionID column. |