IWRAudit Data

[Swathi37]

Hi all,

I have issues collecting the audit information from the server on to the Access database. I created the DSN on the server, scheduled the collect audit data on hourly basis and also configured the access manager. What am I missing? Should the mdb, the catalog and the impromptu reports should be on the server? I don't have write access to the server, can this be done on a shared environment? Please advice.

 

[DoubleD]

So if you don't have write access to the server, where do you have the Access database located? The catalog and Impromptu reports can be anywhere. It's the mdb file you need to populate. It will need to be in a location accessible by the user who is logged on when the process runs. You've pointed auditing to the appropriate DSN in Server/Report Administrator right? (I don't remember which of the administrators you set this in.)

I am what I am based on the decisions I have made.

DoubleD

 

[Swathi37]

Thanks DoubleD!!!
The mdb database is on the server. But when I try to open that I get the readonly message and I can't open that. Could you please provide me few steps as to how to go about this process.
1) Created DSN on the server with the name IWRAudit.
2) The mdb file is on the server.
How to establish the connection for the audit log files to populate the mdb database? Please advice.

Thanks so much!!!
Swathi

 

[DoubleD]

Have you followed all the steps per the Cognos Documentation for IWR Auditing?

If so, look at the generated log file, it should give you an error to troubleshoot.

I am what I am based on the decisions I have made.

DoubleD