How do i get the last time a doc was refreshed?

[MikeKeane]

Hi,
i need to know how many times the reports from corporate docs have been used/refreshed. Is there any way i can get this info and make a BO report from it?
We do not have Webi just the client.

Thanks

 

[pabloj]

Probably a query on the repository could do the trick.
Table OBJ_M_DOCAT and OBJ_M_DOCUMENTS
There is some visual basic to track user activity at

http://www.islink.com/isi_library_downloads_BO_vba.htm

Stick to your guns

 

[MikeKeane]

Hi,
which columns relate to what?
there is one date field as far as i can tell (M_DOC_N_DATE)
but i dont know what this means or what format this is in.

Thanks.

 

[pabloj]

The date is in seconds since 15 december 1970 at midnight.

M_DOC_N_DATE should be the date in which the document was last exported to repository.

Hope this helps Stick to your guns