Issue Fetching List of reports in Audit Logging

[Raghuvir]

Hi all,

i have configured audit logging for cognos on my machine. when i amtrying to fetch the list of reports but running the following URL http://localhost:9300/p2pd/cognos/DSServlet.jsp , i am getting a message as no data available.

Please find the attached screenshot for the same.

Kindly guide/advise me where i am going wrong.

Regards

[Raghuvir]

i have configured ISAPI handler mapping for cognos.

when i check the following table •COGIPF_VIEWREPORT it is blank, but when i check •COGIPF_USERLOGON table, there is information in it.

Kindly advice

Regards

[MFGF]

Hi all,

i have configured audit logging for cognos on my machine. when i amtrying to fetch the list of reports but running the following URL http://localhost:9300/p2pd/cognos/DSServlet.jsp , i am getting a message as no data available.

Please find the attached screenshot for the same.

Kindly guide/advise me where i am going wrong.

Regards

Are you using an audit database? If so, how have you configured it?

What logging levels have you defined on the various services in the Admin Console?

MF.

[Raghuvir]

Are you using an audit database? If so, how have you configured it?

What logging levels have you defined on the various services in the Admin Console?

MF.

Hi MFGF,

Yes i am using an Audit database. i have configured it.

About logging levels, i have defined basic on the various services in admin console. i even changed it to full, but still was not able to get any information on the reports executed.

When i went throught the steps for configuring audit logs on the internet, there was one step where the document says, after creating the DSServlet .class file and making changes to the web.xml under WEB-INF and create the audit database on the cognos connection, we need to run the following URL http://localhost:9300/p2pd/cognos/DSServlet.jsp which will fetch the records for all the reports on cognos connection. but when i run the url its showing me "no data available".

i am trying to figure out what i have missed or where i am going wrong.Request you to guide me on this.

Regards

[MFGF]

When i went throught the steps for configuring audit logs on the internet...

Hi,

We don't know what steps you took. What internet resource did you use?

I'd recommend you start over from scratch, and use the official documentation as your guide. To set up your Audit database initially, use the steps in the Installation and Configuration Guide - Chapter 9 "Configuring a repository for log messages":

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1.1/inst_cr_winux.pdf

Then to set up the audit logging levels and reports, use the steps in the Administration and Security Guide, Chapter 5

http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.1.1/ug_cra.pdf

After that, if you need additional audit information not provided by the out-of-the-box solution, you can install the Audit Extension using the details in this Proven Practices document:

http://www.ibm.com/developerworks/data/library/cognos/development/utilities/page574.html

Cheers!

MF.

[Raghuvir]

Hi MFGF,

Thanks for your guidance again.

it was a mistake from my end, i was only changing the logging level for the services present on the first page. when i changed the logging level for all the entries it started working fine.

Regards