IBM Content Platform Engine (CPE)

Enabling Document View Audit Definition (Get Content Event FileNet)

January 8, 2019

Get content event Filenet 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;

get content event filenet

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 get content event filenet results by query in target os schema in database:

get content event filenet

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

12 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.

    • Reply Junaid Azam August 25, 2020 at 2:55 pm

      Hi Ashish,

      Right now, using this procedure there is no way to count them separately. You cannot distinguish from db if you apply any other event like checkout or deleted. I’ll investigate further and let you know about findings. But every time, if you view document, check-in, checkout, or even delete document, a new entry is stored in event table. You can filter using query by don’t apply DISTINCT option. Thank you.

      • Reply Maria Thoma April 13, 2021 at 11:48 am

        Dear Junaid,
        do we have any update on this? Is there a way to distinguish the downloaded documents?

  • Reply Mohammed Sadath Khan August 24, 2020 at 3:23 pm

    Dear Junaid,

    I Create the GET EVENT then i view the document from navigator but when i see in event table there is no entry under document title column please advice

    • Reply Junaid Azam August 25, 2020 at 2:59 pm

      Hi SADAT,

      document title column is used in docversion table not event table. Please review or share your query. Here is the sample join which extract information from event and docversion tables:
      Note: You just need to modify u1708_documenttitle according to yours.
      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)= ’25-Aug-20′
      ORDER BY modify_user ASC;

  • Reply Maria Thoma April 13, 2021 at 11:34 am

    Hi Junaid,
    I have a question also. Is it possible to log how many times a document was printed? Is there an event that can do this?
    thank you

    • Reply Junaid Azam May 19, 2021 at 1:42 pm

      Hi Maria,
      I’ll let you know the findings.

      • Reply Junaid Azam May 24, 2021 at 4:27 pm

        Hi Maria,

        It not possible to get information about how many a document was printed. I’ve also confirmed from IBM but no option right now. This information is not stored and monitored at back-end. Thank you.

  • Reply Mukul Gupta September 8, 2022 at 7:01 pm

    Hello Junaid,

    I found that the event are getting logged multiple times. e.g. a user has only viewed the document once but the event is getting logged multiple times in the audit table. Did you face a similar challenge ?
    How did you fix it ?

    • Reply Junaid Azam September 14, 2022 at 1:51 pm

      Hi, Yes, you’re right. multiple entried found when you query the content from database. Basically, in IBM FileNet at the same time other events are also triggered which cause multiple entries in the table(s). That is why i have used to truncate sysdate to get the latest one as per requirement. We can investgate to IBM support team to alter this operation at database if they are supported.
      However, i will check it again to get the single row against one record instead of multiple line and get back to you. Thank you.

    Leave a Reply

    error

    Subscribe