Audit Storage page allows configuring storage for captured data. By default data captured to the FluentPro Audit Pro SharePoint list located on the PWA.
If you have a large number of items we strongly recommend to use database as a storage for captured data.
To access Audit Storage configuration in Project Server 2010 navigate to Server Settings→Audit Pro Settings→Audit Storage.
To access Audit Storage configuration in Project Server 2013 navigate to Server Settings→Audit Pro Settings→Audit Storage.
Capturing to Sharepoint Lists
To use SharePoint list for capturing data:
- Select Sharepoint Lists item
- Click Update Settings button
Capturing to Database
In order to use database as a storage for captured data Secure Store database account needs to be configured first.
To use database for capturing data:
- Select Database Tables item
- Provide the following information
- Name of a server where the MS SQL Server is installed
- Name of existing database
- Name of a table where settings will be stored (will be created if does not exist)
- Click Test Connection button to check if provided settings correct
- Click Update Settings button
Copying initial Project server data
In order to have initial Project server data (values of projects, tasks, resources fields) in FluentPro Audit Pro database do the following:
- Configure the Database Tables section.
- Check Copy Project Server data to audit database checkbox
- Provide a farm administrator credentials
- Click Update Settings button