Remove ADPermissions Tables
If it becomes necessary to clear the ADPermissions Data Collector tables and views to resolve an issue, create a new job using it as the query source and select the Remove Tables category. The Connection Profile should be the same one that you used for the associated Active Directory Permissions Analyzer > 0.Collection Job. Follow the steps.
This query task deletes collected data.
Step 1 – Create a new job and assign a query using the ADPermissions Data Collector.
Step 2 – In the Active Directory Permissions Data Collector Wizard, on the Category page select the Remove Tables category and click Next.
Step 3 – On the Results page, select all the Available Properties and click Next.
Step 4 – Click Finish to close the Active Directory Permissions Data Collector Wizard. Click OK to close the Query Properties window.
Running the job removes all of the ADPermissions standard reference tables from the database.
Remember, this job deletes data from the Access Analyzer database. Ensure you configure the job correctly before you run it.
Never leave the query task selected after you run the job. Accidental data loss can occur.