In System Center 2012 R2 Configuration Manager, special views, called extraction views, can be enabled to facilitate the tracking of collection membership changes. These views are of primary use in a data warehousing scenario.

Note
The extraction views are not enabled by default, and may impact site performance.

To Enable Extraction Views

  1. Run the following SQL stored procedure.

    SQL  Copy Code
    exec dbo.spExtEnableDeleteDetection 1
    

To Disable Extraction Views

  1. Run the following SQL stored procedure.

    SQL  Copy Code
    exec dbo.spExtEnableDeleteDetection 0
    

See Also