Cognos Analytics

 View Only
  • 1.  Cognos 11.0.11 - Audit Table area to find 'report owner'

    Posted Mon September 30, 2019 10:19 AM

    ​Hello,

    I'm trying to find the audit table/field that give me the 'report owner' not the person executing the report or scheduling the report.

    Where can I find this?

    Thanks,
    Jen



    ------------------------------
    Jenifer Broughton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Cognos 11.0.11 - Audit Table area to find 'report owner'

    Posted Tue October 01, 2019 03:30 AM
    Hello Jenifer,

    As far as I know you can only find this in the COGIPF_ACTION table. Create a report based on package 'AUDIT' and select all the objects from 'Actions by Object'. Filter column OPERATION on value 'ADD' and column TARGET_TYPE on value 'REPORT' (experiment with the other available values as I am not quite sure of this is the only one, but at least it is a start.)
    Drawback is that this table is by far the largest table in the AUDIT environment so querying could be slow.

    Cheers
    Han

    ------------------------------
    Analytical Engine
    ------------------------------



  • 3.  RE: Cognos 11.0.11 - Audit Table area to find 'report owner'

    Posted Tue October 01, 2019 07:09 AM
    Perhaps the Audit Extension would help with some of your inquiries
    https://developer.ibm.com/tutorials/ibm-cognos-11-audit-extension/

    ------------------------------
    NORBERT Bracke
    ------------------------------



  • 4.  RE: Cognos 11.0.11 - Audit Table area to find 'report owner'

    Posted Tue October 01, 2019 08:20 AM
    Thanks Han, I will check into this audit table.
    @NORBERT Bracke  I'm working on getting the audit extension.  Is there a lot of setup when implementing? Are there any drawbacks from having this​​ in addition to the normal auditing?

    Thanks!

    ------------------------------
    Jenifer Broughton
    ------------------------------



  • 5.  RE: Cognos 11.0.11 - Audit Table area to find 'report owner'

    Posted Mon September 16, 2024 10:12 AM

    Hi Jenifer Broughton

    Have you found ?
    How can i get the report owner name from the audit db 

    Thanks



    ------------------------------
    Rahul Raut
    ------------------------------