Restoring and reading AdaxesLog.db3

Question

We have a need to restore and read audit logs from a backup. We have restored the backup but are looking for guidance on the easiest method to access logs within this file.

Thanks in advance!

Comments

Hello,

As far as we understand, you need to export the logs into an external file format that you can provide for audit purposes, is that correct? Will CSV files do for you? Then, you can export the logs using a PowerShell script. For an example, see the following script in our repository: http://www.adaxes.com/script-repository ... v-s183.htm.

If you need to keep logs for long time periods, we recommend storing them in an external MS SQL database. It is suitable for storing big amounts of log records. For more information, see section External Database in the following help article: http://www.adaxes.com/help/?LoggingConc ... html#extdb.

---

So we understand the capability to export logs to CSV and to connect to SQL and we are planning to implement the latter. Right now we have logging enabled for 6 months. We received an audit request that exceeded that time period - we need information from February. We have restored the AdaxesLog.db3 file - we just need some instructions on how to open it up and read the data.

The first link you sent provides a powershell script to bind to the live AdaxesLog.db3 file:

# Bind to the service log
$path = $Context.GetWellKnownContainerPath("ServiceLog")
$serviceLog = $Context.BindToObject($path)

Is there a way to point $path to an alternate .db3 file?

Thanks again!

Answer 1

Hello,

There's no way how you can point Adaxes Service to use an alternate .db3 file, however there are 2 alternatives that you can use:
1.AdaxesLog.db3* is an SQLIte database file. You can export the database using any tool for SQLIte database management. The database structure is available in the following help article: http://www.adaxes.com/help/?LoggingConc ... gDBDiagram.

2.Alternatively, you can do as follows:

1. Install Adaxes Service on another computer and share the service configuration with your current service. To do this, on the Service Configuration page of the installation wizard, do the following:

   • Select Share configuration.
   • Click Select.
   • Select the server where Adaxes service is installed at the moment.
   • Specify credentials of Adaxes default service administrator (the user that you specified when installing Adaxes service).
     

2. When the installation completes, launch Adaxes Administration Console and connect to the new Adaxes service. Once connection is established, this means that the new service has replicated configuration information from the old one.

3. Stop Adaxes Service.

4. Replace the AdaxesLog.db3 file of the new service with the necessary one.

5. Start Adaxes Service.

6. Perform the export using the script from the repository.

Comments

Fantastic thank you - will let you know our results.

Have a Happy Thanksgiving!

---

Thanks, the same to you!