You are viewing limited content. For full access, please sign in.

Question

Question

Merging Audit Trail Databases

asked on March 9, 2016

I have a client who upgraded to LF 10 from version 8.  In Audit Trail, we created a new database for LF 10 moving forward.  The question they've posed to us is can they merge the two databases so they can access both of them in Audit Trail?

 

Thanks,

 

Shannon

0 0

Replies

replied on March 9, 2016

All of their audit data (from version 8 through 10) is stored in the "AUDIT" folder, inside of the windows path where the repository resides.  Only portions of the data are only written to the SQL database so that the Audit Trail Reporter can view it.

For example, if you have Audit Trail setup to make the last 7 days worth of data available to report on, only the last 7 days worth of data will be loaded into the SQL database.  However, all of the Audit data (from the time the system was installed until present day) is stored as .log files in that AUDIT folder.

So the SQL database is really irrelevant. 

1 0
replied on March 9, 2016

In addition to Mike response, the Audit folder can be located in a network drive different than the one setup for the Repository. 

To known the exact location go to Laserfiche Administration console, go to Auditing node, then check the Audit file location section to find out the exact path for the Audit folder. Also keep in mind that the Rollover Directory might be in a different path as well, this is the folder that contains the rollover log audit files. There is no need to merge two different database, if you install Audit Trail version 10 on top of Audit Trail 8, then the current Audit Trail database for version 8 will be updated , this means the database schema will be updated. Depending on how you have setup the Audit Trail range dates or days you will need to either add another Date Range to load more data from the log files.  If you have it set to load the last 30 days then the process should be automatically. 

1 0
replied on March 9, 2016

Thanks for the answers!  A follow up I got from our client is how can we point the current version of Audit Trail back towards the old data?

0 0
replied on March 10, 2016

When you upgraded to v10, did you manually change the location of the Audit Logs?  If not, both the old and the new data should be available in Audit Trail.  You just need to make sure that the Date Range (in the Audit Trail Config page) is set back far enough to include the v8 data (see screenshot).

Screenshot.PNG
Screenshot.PNG (17.91 KB)
0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.