Export (0) Print
Expand All

How to Enable and Disable Extraction Views

Updated: November 1, 2013

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

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.

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

To Enable Extraction Views

  1. Run the following SQL stored procedure.

    exec dbo.spExtEnableDeleteDetection 1
    

To Disable Extraction Views

  1. Run the following SQL stored procedure.

    exec dbo.spExtEnableDeleteDetection 0
    

See Also

 

Community Additions

Show:
© 2014 Microsoft