Cognos Analytics

 View Only
Expand all | Collapse all

SQL query for fetching report name & group/role name from content store

  • 1.  SQL query for fetching report name & group/role name from content store

    Posted Mon March 13, 2023 06:47 AM

    Hi everybody,


    I need to create a Cognos report from the content store database which will provide details of report_name or dashboard and roles/groups that has access to this report.

    Regards,

    Vaibhav



    ------------------------------
    Vaibhav Pujari
    ------------------------------


  • 2.  RE: SQL query for fetching report name & group/role name from content store

    IBM Champion
    Posted Mon March 13, 2023 09:51 AM

    Hi,

    This sounds like something the Audit Extension will provide out-of-the-box. Have you looked at installing it?

    https://developer.ibm.com/tutorials/ibm-cognos-11-audit-extension/

    Cheers!

    MF.



    ------------------------------
    Mark Fry
    Technical Consultant
    ------------------------------