Clear ADActivity Tables

When troubleshooting an ADActivity issue, you sometimes need to clear the standard reference tables. Follow these steps.

Step 1 – Create a new job and assign a query using the ADActivity Data Collector.

Step 2 – In the Active Directory Activity DC Wizard on the Category page, select the Remove Tables category task.

Step 3 – Click Next to go to the Results page. Optionally, select the Success checkbox to display a confirmation of successful removal in the results after the job runs.

Step 4 – Click Next and then Click Finish to close the Active Directory Activity DC Wizard. Click OK to close the Query Properties window.

warning

When you run the job, it removes all ADActivity standard reference tables from the database.