0 votes

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!

by (610 points)
0

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.

0

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!

1 Answer

0 votes
by (216k points)
edited by
Best answer

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.

0

Fantastic thank you - will let you know our results.

Have a Happy Thanksgiving!

0

Thanks, the same to you!

Related questions

0 votes
1 answer

Hello, I'm doing an upgrade to 2013.2. Is there a way to preserve the AdaxesLog.db3 content from the old version to the current version? I tried to replace the file ( ... "failed to load log records". Unable to find assembly 'System.Data.SQLite....' Thanks,

asked Dec 10, 2013 by BradG (950 points)
0 votes
1 answer

We have a test instance of ADAxes in our testing lab. We are required to create and test security roles in this environment before adding them into production. Is ... back up a specific security role definition and restore from one environment to another?

asked Feb 12, 2012 by BradG (950 points)
0 votes
1 answer

I've recently installed new Adaxes servers in my environment. Following the instructions: http://www.adaxes.com/help/HowDoI.Manag ... ation.html I've backed up the old web ... come over. Do I need to manually move the sub-sites and reconfigure within inetmgr.

asked Jun 5, 2019 by JHA-Matthew (70 points)
0 votes
1 answer

Trying to read data from as SQL database and .ExecuteReader() appears to be successful, but while .Read() must be returning False. Please review the code below ... # Close the database connection and release resources $command.Dispose() $connection.Close() }

asked Oct 17, 2016 by sbanks (270 points)
0 votes
1 answer

Hi, Is there a simple way to read the Exchange AD attributes without having to use the custom Exchange ADSI interface API? I'm trying to write an Adaxes Scheduled Task ... Limit") - other than the fact that the command doesn't recognise the property! Thanks

asked Aug 19, 2015 by firegoblin (1.6k points)
3,326 questions
3,025 answers
7,724 comments
544,678 users