Enterprise Vault™ Auditing

To access inactive old audit databases using the OData web service

1. 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.
2. Double-click the Audit_Schema_Upgrade script to open the file in the SQL Server Management Studio.
3. 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]

4. Double-click the AuditDBRoles script to open the file in the SQL Server Management Studio.
5. 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]

6. After the script is executed successfully, click New Query in the toolbar.
7. 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 
   

8. 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.
9. 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=""/>