Search <book_title>...

Enterprise Vault™ Auditing

Last Published: 2022-09-04

Product(s): Enterprise Vault (14.3)

About this guide
1. Introducing this guide
2. Where to get more information about Enterprise Vault
  1. Enterprise Vault training modules
Introducing Enterprise Vault auditing
1. About Enterprise Vault auditing
Setting up auditing
Viewing the audit database entries
Auditing for data protection compliance
1. Auditing general delete operations
  1. Example query search for general item delete audit entries
2. Auditing privileged delete operations
  1. Example query search for privileged delete audit entries
Appendix A. Format of audit database entries
1. The format of audit database entries

Accessing earlier versions of inactive audit databases using the OData web service

To allow the OData web service to access an Enterprise Vault 12.3 or earlier version of the audit database, you need to configure the details of that database on the SQL Server and the OData web.config file on the Enterprise Vault server.

To access inactive old audit databases using the OData web service

Copy the Audit_Schema_Upgrade and AuditDBRoles scripts from the Enterprise Vault installation folder (for example C:\Program Files (x86)\Enterprise Vault) to the SQL server that hosts the auditing database.
Double-click the Audit_Schema_Upgrade script to open the file in the SQL Server Management Studio.
Before executing the script, replace the database name with the name of the database that you want the OData web service to query.
USE [NameOfTheOldAuditDatabase]
Double-click the AuditDBRoles script to open the file in the SQL Server Management Studio.
Before executing the script, replace the database name with the name of the database that you want the OData web service to query.
USE [NameOfTheOldAuditDatabase]
After the script is executed successfully, click New Query in the toolbar.

Execute the following script to add users to the EVODataAdminrole. Note that to add more users to the role, you need to edit the value of the @User parameter and rerun the script for each user.

USE [NameOfTheOldAuditDatabase] 
GO
DECLARE       @return_value int
EXEC   @return_value = [dbo].[AddWindowsUserToRole]
              @Role = EVODataAdminRole,
              @User = N'domain\username'
SELECT 'Return Value' = @return_value
GO

Verify whether the user is added to the SQL Role "EVODataAdminRole" that is available under the old Audit database. Double-click NameOfTheOldAuditDatabase > Security > Roles > Database Roles > EVODataAdminRole, and select Properties.
On the Enterprise Vault server, open the web.config file from installpath\EVOData. Update the SQL server name and the name of the audit database that you want the OData web service to query.
```
<add key="AUDIT_SQL_SERVER_NAME" value=""/>
<add key="AUDIT_DATABASE_NAME" value=""/>
```