Configure the Audit Log Viewer

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.

After the audit log viewer has been installed as described in Install the Audit Log Viewer, some of its features can be configured to meet your requirements:

Visibility and order of the columns
Visibility of the viewer header (logo and title), such as hiding it when showing the viewer as an external property page for document types as described in the Accruent Meridian Enterprise Configuration Guide.
Modify the text of the event descriptions as described in Localize the Audit Log Database

Change Date / Time Format of Viewer

To change the date and time format used in the audit log viewer:

Navigate to C:\inetpub\wwwroot\BCEnterprise\Languages on your machine.
Open English.xlsx.
Change the date / time formats in the following rows:
- Row 3 – DateFormat – this value MUST be the same as the ServerDateFormat value.
- Row 4 – DateTimeFormat – this value MUST be the same as the ServerTimeFormat value.
- Row 9 – ServerDateFormat
- Row 10 – ServerTimeFormat
Refer to the table below for the supported date / time formats.
Save your changes.
Reset Internet Information Services (IIS).

Date / Time Formats Supported for Audit Log
Category	Input	Output
Date	M/d/yyyy	4/5/2017
Date	M/d/yy	4/5/17
Date	MM/dd/yy	04/05/17
Date	MM/dd/yyyy	04/05/2017
Date	yy/MM/dd	17/04/05
Date	yyyy-MM-dd	2017-04-05
Date	dd-MMM-yy	05-Apr-17
Date	dddd, MMMM d, yyyy	Wednesday, April 5, 2017
Date	MMMM d, yyyy	April 5, 2017
Date	dddd, d MMMM, yyyy	Wednesday, 5 April, 2017
Date	d MMMM, yyyy	5 April, 2017
Time	h:mm tt	9:40 AM
Time	hh:mm tt	09:40 AM
Time	h:mm	9:40
Time	hh:mm	09:40
Time	h:mm:ss tt	9:40:07 AM
Time	hh:mm:ss tt	09:40:07 AM
Time	h:mm:ss	9:40:07
Time	hh:mm:ss	09:40:07

Change Visibility and Order of Columns

To change the visibility and order of the columns:

Open the web.config configuration file of the audit log viewer in any text editor. By default, the file is located in C:\inetpub\AMM\WebExtensibilityDBViewer.
In the appSettings section of the file, modify the values of the settings described in the following table.

Column settings
Setting	Description
AuditTableColumns	Contains add elements for each column name. The key attribute is the name of the column. Set the value attribute to true to show the column. Set it to false to hide the column. Arrange the order of the add elements to change the order of the columns in the viewer.

Hide Viewer Header

To hide the viewer header:

In the URL to show the viewer, set the HideHeader parameter to a non-zero number. For example, the following URL will show the audit log viewer without the header:

http://localhost/WebExtensibilityDBViewer/AuditView.aspx?MachineName=MyServer&VaultName=MyVault&HideHeader=1