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 below
-
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).
|
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.
| 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
