Chat now with support
Chat with Support

NOTICE! We are upgrading our support telephone services, implementing Genesys, starting the week of May 26, 2025

ControlPoint 8.8 - User Guide

Preface Getting Started with ControlPoint Using Discovery to Collect Information for the ControlPoint Database Cache Searching for SharePoint Sites Managing SharePoint Objects Using ControlPoint Policies to Control Your SharePoint Environment Managing SharePoint User Permissions Data Analysis and Reporting
Specifying Parameters for Your Analysis Analysis Results Display Generating a SharePoint Summary Report Analyzing Activity Analyzing Object Properties Analyzing Storage Analyzing Content Generating a SharePoint Hierarchy Report Analyzing Trends Auditing Activities and Changes in Your SharePoint Environment Analyzing SharePoint Alerts Analyzing ControlPoint Policies Analyzing Users and Permissions The ControlPoint Task Audit Viewing Logged Errors
Scheduling a ControlPoint Operation Saving, Modifying and Running Instructions for a ControlPoint Operation Using the ControlPoint Governance Policy Manager Using Sensitive Content Manager to Analyze SharePoint Content for Compliance Using ControlPoint Sentinel to Detect Anomalous Activity Provisioning SharePoint Site Collections and Sites Default Menu Options for ControlPoint Users About Us

Creating the Audit_Log_Transfer Database Table

The first step in the process of setting up an audit log data archive is to create the Audit_Log_Transfer  table.  You can create this table on the server and in the database of your choice.  It is important to note, however, that the archiving process does not compress audit log data, but rather transfers it “as is” from the content database tables to the Audit_Log_Transfer table.   (Think of this table as a data warehouse.)  Therefore, you should keep space requirements in mind when selecting the location for this table, especially if you are archiving data from large, active site collections for which an extremely large number of audit records may be generated.

Log in Account Requirements:

On the server that hosts the database to which you want to archive audit log data, you must be logged in with an account that has permissions to create a new database table in the selected database.

TIP:  You may want to consider logging in as the ControlPoint Service Account.  Because it is the account that actually writes  records into the database, you would not need to grant permissions to any other account.

To create the Audit_Log_Transfer Database Table:

1If you want the audit archive data to reside in a new database, create that database on the  appropriate server.

2On the Web front-end server on which ControlPoint was initially installed, navigate to the folder C:\Program Files\Metalogix\ControlPoint\ControlPointFeatures\Packages.

3If you will be creating the Audit_Log_Transfer Database Table on a different server, copy the file script_create_audit_archive_tables.adt to that server.

4Open the file script_create_audit_archive_tables.adt in SQL Server Management Studio.

5Copy all of the text in the file.

6In the Object Explorer (left pane), select the database in which you want to create the archive table.

7Right click and choose New Query.

8Paste the text that you copied into the right pane.

9From the Query menu or toolbar, choose Execute to create the Audit_Log_Transfer table in the selected database.

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating