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
------------------------------
Original Message:
Sent: Mon March 13, 2023 06:46 AM
From: Vaibhav Pujari
Subject: SQL query for fetching report name & group/role name from content store
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
------------------------------