How to Get the List of Changes in a Collection

  • Article

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

The following example shows how to get the list of changes in collection membership System Center 2012 R2 Configuration Manager by using the SCCM_Ext.vex_FullCollectionMembership view. This is of primary interest in specific data warehousing scenarios.

Important

The use of this query requires that extraction views are enabled. See How to Enable and Disable Extraction Views for more information.

To Get the List of Changes in a Collection

  1. Initial query for full sync:

    select * from SCCM_Ext.vex_FullCollectionMembership where ChangeAction='U'

  2. Using the maximum rowversion returned from the results, run the delta query:

    select * from SCCM_Ext.vex_FullCollectionMembership where rowversion > <maximum rowversion>

    For example:

    select * from SCCM_Ext.vex_FullCollectionMembership where rowversion > 0x00000000001F573B

See Also

Tasks

How to Enable and Disable Extraction Views

Reference

SMS_Collection Server WMI Class

Other Resources

Configuration Manager Collections