Question

Post Audit trail log data to other third party application as RAW text on real time basis?

Updated January 3, 2018

asked on December 24, 2017

Hello everyone,

I've been wondering if we can send the Audit Trail data to other third-party applications for the purpose of enhancing the Laserfiche Reports.

As you know Audit Trail logs are encrypted and the only way I know is to export each report results as a CSV file which can be used to import data to other systems but manually!

Of course, exporting reporting reports results will take a long time as data increases, so this will not be a practical way to do it.

Please, guys, help if there is any way to do it!

Thanks and Regards.

1 0

Replies

replied on December 25, 2017

Hi Mohamad,

As you said the audit logs are encrypted. However the Audit Trail Report software decrypts a predefined windows (last x days, or date range) into an MS or Oracle database. It refreshes about every five minutes, so is close to real time.

I've worked with a number of customer who use the Audit Trail Report database as the source for their other reporting tools.

Is that the kind of solution you were after?

-Ben

1 0

replied on December 25, 2017

Hi Mohamed,

There are a number of tables, so it depends on what information you need. I'm afraid you'll have to do some digging and experimenting of your own. However, to get you started, have a look at audit_entry, audit_event, audit_prop, audit_propval, and audit_propset. These will give you the history of metadata change.

Regards,

Ben

1 0

replied on December 25, 2017

Yeah, that's great!

so can you help me to with the table names of Audit Trail DB to connect and other related info I should know prior to connecting to the DB.

Thanks and Appreciate your kind help!

0 0

replied on December 25, 2017

Thanks Ben for Your help, I'll try my own digging and get back to you, Thank you.

0 0

replied on January 2, 2018

Just to clarify: the log file format is not documented and the data can be compressed, but there is no encryption.

0 0

replied on January 3, 2018

Hi Brian,

I thought VERS required encrypted logs files, to meet the requirement that they be unalterable. But you're saying that's not the case, right?

0 0

You are not allowed to follow up in this post.

Question

Question

Post Audit trail log data to other third party application as RAW text on real time basis?

Replies

Sign in to reply to this post.