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

Question

Question

field timestamp in sql

Updated June 29, 2017
asked on June 28, 2017

Hello, 

I want to find out the last updated or modified date of template field in the database.

Is there any way to find in the database when the specific field of the template has been modified?

 

We have a certain reporting runs from this Laserfiche data on once a week and some of the records are skipping to pick o the report but If I run the report query after few days of the ideal report day, it is picking up that missing record. 

So, I just want to see if I can find the field timestamp of when the field is modified, I can figure out why that record is not picked up at the report day.

 

Any help would be greatly appreciated.

Thank you

Rajan

0 0

Replies

replied on June 28, 2017 • Show version history

Rajan,

The metadata/field table for the repository does not store any timestamp information, just the field identifiers, values, etc.

I think your best bet is use Audit Trail to track the relevant events. Unless I'm mistaken, Audit Trail should be capable of collecting the information you require.

Once Audit Trail is configured and the logs are available in a SQL database, you should be able to replicate/query it once you know what to look for.

1 0
replied on June 29, 2017

Thank You Jason,

That's what I understood that fields are not storing the timestamp, but tried to see if there is any other way to find that out.

Jason, would you please share some information about how do I setup audit trail?Any relevant blogs or other documentation, So that I can set up that on my system and will track of the fields.

 

Thank you,

Rajan

0 0
replied on June 29, 2017 • Show version history

Audit Trail is an add-on to the Laserfiche system.  If you have purchased the licensing, then during the LF Server install, you can install the Audit Trail Reporter.  If LF Server is already installed, then go to Add/Remove programs (or re run the installer) and select Modify to add the Audit Trail Reporter.

In the Audit Trail Reporter configuration, you set up a DB that it uses to load the Audit data into and you set up a time period for which the Audit data will be loaded.  Then you would have your DB source to query against.

To select what activity is being audited, in the User/Group profile window of the Laserfiche Admin Console, you have an Audit tab that allows you to select what events are being captured.  Usually, this is set on the everyone group and inherited by all users.

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...