Create an Audit Log Database

Note:

This task is required only if the audit log data must be stored in a standalone external database. It is not required if the audit log data will be stored in Meridian Enterprise Server.

The audit log feature requires an existing external database in which to store the vault event information. By default, the Meridian Enterprise does not create this database automatically. The database must be created by a database administrator. Scripts for SQL Server and Oracle are installed by the Meridian Enterprise setup program for your convenience that will create the database and the necessary schema. The scripts must be run by a user with sufficient rights to perform the actions in the scripts.

  • If the subscription database already exists, the scripts will delete it first and then recreate it.

  • Depending on the amount of activity in your vaults, the audit log database can grow quite large. If the amount of disk space allowed for the database is restricted, errors can occur and background processes may fail. We highly recommend that you allow unlimited growth of the database with the database management tools and periodically monitor the database size.

Audit log data is stored using the UTC time zone, and is not based on the server time.

ClosedSQL Server

To create an audit log database in SQL Server:

  1. Copy the following script file from the Meridian Enterprise application server to the SQL Server host computer:

    C:\Program Files\BC-Meridian\Program\BC Audit\BCAuditTrailDB.sql

  2. On the SQL Server host computer, navigate to the folder where you copied the files in step 1.

  3. Run the script using the sqlcmd command-line program and one of the following examples:

    Note:

    • We recommend using the database name <VaultName>AuditLog.

    • If the database server is running SQL Server Express, SQL Server Small Business, or another edition that creates a default named instance when the software is installed, specify the name of the database server and the SQL Server instance name together, for example, <ServerName>\SQLEXPRESS or <ServerName>\MSSMLBIZ.

    sqlcmd -S <ServerName> -E -i BCAuditTrailDB.sql -v DatabaseName = "<AuditDatabaseName>"

    Or to use different credentials than your own:

    sqlcmd -S <ServerName> -U <UserName> -P <Password> -i BCAuditTrailDB.sql -v DatabaseName = "<AuditDatabaseName>"

ClosedOracle

To create an audit log database in Oracle:

  1. Copy the contents of the following folder on the Meridian Enterprise application server to the Oracle host computer:

    C:\Program Files\BC-Meridian\Program\BC Audit

  2. On the Oracle host computer, navigate to the folder where you copied the files in step 1.

  3. Start SQL *Plus.

  4. Run the following command:

    run @ORACreateTables.sql

2021 R2

 

Accruent logo in white text.

© Copyright Accruent 2023Privacy PolicyTerms of UseLegal