Clarity

Hi all,I have uploaded several documents to the knowledge store and although I can see the history from the application I would like to be able to report on it.Does anyone have the SQL required to extract knowledge store document access history?  Regards,Matt

Hi Matt,You can query from CLB_DMS_[*] tables to report on knowledge store documents  or document manager(collaboration tab) documents. Below is the query to get some details  select files.created_date,
            files.name,
            files.mime_type,
            files.file_created_date,
            folders.path_name||'/'||folders.name,
            ver.version_number,
            (select first_name||last_name from cmn_sec_users where id=history.last_updated_by) modified_by
from     clb_dms_files files,
            clb_dms_folders folders ,
            clb_dms_versions ver,
            clb_dms_histories history
where folders.id=files.parent_folder_id
 and   ver.file_id=files.id
 and   ver.id=history.version_id
order by file_created_date desc    You can join with CMN_SEC_USERS to get created_by, last_updated_by details, join with other CLB_DMS_[*] tables to get more information.  Hope this helps  ThanksSiva  

Siva,  thats fantastic, thankyou very much!  Regards,Matt