IBM Content Platform Engine (CPE)

Enabling Document View Audit Definition (Get Content Event) in FileNet CPE

January 8, 2019

There is a requirement that how we can fetch information about the users how many time(s) they view particular document(s).

Following are the steps to achieve this:

  1. Logon to ACCE Console.
  2. Go to Target Object Store, Data Design, Document Class, and click on particular class where you want to enable document view audit log.
  3. Click on Audit Definition tab. Crate a new one, select Get Content Event from drop down and save and apply as mentioned below:
get_content_event_filenet
filenet_audit_definition

Now let suppose the user who has rights to view document on that particular document class and he or she viewed document in IBM Case manager Client like;

ibm_advanced_case_manager

Once done, when user view the document as you enabled audit definition on document class information will be captured in EVENT table in Target Object Store schema. You can simply query and check the results by using the following:

SELECT DISTINCT e.modify_user,trunc(e.modify_date) modify_Date,d.u1708_documenttitle
FROM EVENT e, DOCVERSION d
WHERE e.source_object_id=d.object_id
AND TRUNC(e.modify_date)=(SELECT TO_CHAR(SYSDATE,’DD-MON-YY’) FROM DUAL)
ORDER BY modify_user ASC;

To examine the audit log, you will see the following results by query in target os schema in database:

viewing_event_log

Furthermore, you can also create a search template to view audit log results.

  • Create a search in the administration console: In the domain navigation pane, click the object store. In the object store navigation pane, click the Search folder.
  • Refine your search criteria In the Simple Search tab: Select Event for the value of Select from table. ( i cannot find this) Select the columns and set other search options as needed.
  • Click Search. The results are displayed on the Search Results tab.

You Might Also Like

3 Comments

  • Reply Cristian G Creo April 16, 2020 at 10:10 pm

    Dear Junaid Azam.
    I saw your post on how to make a query to the “Event” table to get audit data about a document.
    I would like to ask you about a question. From ACCE, you can see the properties and values by which a document was modified, when the “Update” event is being audited. What I can’t do is view that data from the Event table. Is there any way to obtain such information.?
    I have also tried using the API and cannot get the data.

    Thank you in advance for the help you can give me.
    Best regards.
    Atte. Cristian G. Creo
    ccreo@grupolpa.com

  • Reply Junaid Azam April 17, 2020 at 12:32 pm

    Hi Cristian,
    The example i quote in this post about every time an entry will be marked in events table when user will click on particular document class. As you see the query, it also joined with docversion table where u1708_documenttitle is property name. If you update values of properties of document class, they are also stored in the docversion table. You can refine the query to retrieve the results.
    For more details, please review https://www.ibm.com/support/knowledgecenter/SSNW2F_5.5.0/com.ibm.p8.ce.admin.tasks.doc/p8pcc197.htm
    Secondly, Let say, If you update property value from 123 to 456 than it will be updated to all of rows with new values.
    In this query, d.u1708_documenttitle and d.u39e8_plotno are retrieved from docversion table. You have to modify the query to see the results accordingly.
    select distinct e.modify_user,trunc(e.modify_date) modify_Date,
    d.u39e8_plotno, d.u1708_documenttitle
    from event e, docversion d
    where e.source_object_id=d.object_id
    order by modify_date desc

    If not, please send an email to junaid.azam@iparagons.com with your requirement. Thank you.

  • Reply Ashish July 22, 2020 at 12:47 am

    hi Junaid

    Get content method also counts the downloaded documents. Is there a way to check for only documents that are viewed and not downloaded. I am using ICN with FileNet and have specific requirement to count viewed documents.

  • Leave a Reply

    error

    Subscribe