How to configure Audit databse for Cognos8?

[Alex555]

I would like to configure Audit databse for Cognos8.  Under IBM Cognos Configuration :- Environment-Logging-New Resource-destination-(Tye:-Database). I  ahve creates an Audit database. Right now login is happening in a log file. How can i configure logservice so that it will start putting log information in Audit databse rather than log file

Alex

[cognos_guru]

There is very extensive documentation on this topic located on the IBM Cognos support site.  I'd suggest reading through that documentation as it gets complicated.

[sasdev]

1. Log into Cognos Connection
2. Go to Cognos Administration
3. Click the Configuration tab, and then click Dispatchers and Services.
4. Under the Actions column, beside http://<machine_name>:9300, click Set properties, and then click the Settings tab.
5. Under the Value column, set the logging level to BASIC for all services and the dispatcher, and then click OK.
6. Repeat steps 4 & 5 to set the same logging levels for other registered dispatchers.
7. Log off.
8. Log onto your SQL Server or other data warehouse application and check out the tables in the Audit database. If you

[david.stachon]

cognos_guru is correct, you will want to go through the documentation for this.....

http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.c8bi.ug_cra.doc/ug_cra_id2986Logging.html

you'll want to research the level of logging you require, and setting up the xml datasource to track logins is a little tricky.

[Zolhus]

Thanks cognos_guru and david.stachon.

Your suggestions helps me a lot.

Rodrigo (Zolhus) Spadaccia