Audit Trail Data in DLO

The ability to record Audit Trail data has been in Desktop and Laptop Option (DLO) since version 8.0 SP1. This allows you to log 'Restores and Migrations' and\or 'Configuration Changes' and then report on those, using default reports in the DLO Administration Console. To Enable this data, please ensure the relevant options are Ticked under Tools - Options - Global Settings - Options  screen of the DLO Administration console (see screenshot below) .

The Audit Trail data can also be Archived to CSV files before that historical data is purged from the database. It has always been possible to manually run the archive and\or purge via DLOCommandu commandline Utility (see DLO Administration Guide for details), but since DLO 9.0 SP1, it is also possible to configure a scheduled archive\purge from the Tools - Options - Global Settings - Options - Auto Archive Audit Trail setting of the DLO Administration Console (see screenshot below).

Once data has been Archived\purged, those entries will not be available for use in DLO reports.

Archived Audit Trail Data

Audit Trail data will be archived to a folder you specify, with a unique subfolder created, called 'Audit_yyyy-mm-dd-hh-mm-ss'. That sub-folder will contain two files;

• DynamicDataAudit_.cab   (containing the Restore and Migration data entries)
• StaticDataAudit_.cab   (containing the Configuration Changes data entries)

Each .cab file holds a .CSV (comma separated) file with the exported Audit Trail data, for review outside of DLO. If there is no data to be archived, these .csv files will have column headings only.

Since DLO 9.4, the archived data is exported using the same format and detail as the output of the Audit Trail reports in the DLO Administration Console.

In earlier DLO versions, the exported data was the the same, but the operation (i.e.restore, migration, etc) was only recorded only as a numerical value, instead of the description we have now (see explanation below).

It is recommended to upgrade to DLO v9.4 or later, to get the benefit of these export format changes.

To assist with reviewing\reporting on the data that has been archived in DLO 9.3.3 or earlier, the numerical values or acronyms are explained below;

DynamicDataAudit_.csv file:-

'OperationId' column values, recorded in the DynamicDataAudit_.csv file;