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:

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

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

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

    For example:

    SQL  Copy Code 
    select * from SCCM_Ext.vex_FullCollectionMembership where rowversion > 0x00000000001F573B

See Also