How to Enable and Disable Extraction Views
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.
Note
The extraction views are not enabled by default, and may impact site performance.
To Enable Extraction Views
Run the following SQL stored procedure.
exec dbo.spExtEnableDeleteDetection 1
To Disable Extraction Views
Run the following SQL stored procedure.
exec dbo.spExtEnableDeleteDetection 0
See Also
Tasks
How to Get the List of Changes in a Collection
Reference
SMS_Collection Server WMI Class