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

Question

Question

Document last opened

Updated February 5, 2016
asked on February 4, 2016 • Show version history

Hi,

We are thinking of ways of moving laserfiche documents that are not in used into slow (cheap) storage.

Is there any way of finding in SQL or a LF Search when was a document last opened?
The last modification date doesn't work for us.

I think this info could be Audit Trail, but we only keep 6month of audit in the database, and the files are not readable. 

Thanks

Gian

 

0 0

Answer

SELECTED ANSWER
replied on February 4, 2016

This data is not stored in the repository's database, but it is available in the audit log provided that you recorded view events for all of the relevant users.

1 0

Replies

replied on February 4, 2016

What do you mean by 

The last modification date doesn't work for us

I would recommend getting each file creation date and then comparing that with its last modification date. if difference is large then move that file to cheap storage.  you could use advanced serach syntax in search repository in workflow to achieve this. 

0 0
replied on February 5, 2016

The modification date doesn't work for us because is updated every time the metadata is updated. We have lots of workflows updating metadata, even in old documents.

 

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

Sign in to reply to this post.

Details
Related Posts
Loading ...