If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos Office Audit

Started by Cognos KW, 25 Mar 2015 07:17:24 PM

Previous topic - Next topic

Cognos KW

Hi Guys,

Is there a column in Audit database tables which captures the device/Tool from where Cognos report was executed?
I want to check usage stats of Cognos office application (When a user drags a report in Excel or word using Cognos office). In audit reports I can track all the report executions but I can't find a field which says the report was executed from office.


Your assistance would be very much appreciated!

Cheers,
KW

MFGF

Quote from: Cognos KW on 25 Mar 2015 07:17:24 PM
Hi Guys,

Is there a column in Audit database tables which captures the device/Tool from where Cognos report was executed?
I want to check usage stats of Cognos office application (When a user drags a report in Excel or word using Cognos office). In audit reports I can track all the report executions but I can't find a field which says the report was executed from office.


Your assistance would be very much appreciated!

Cheers,
KW

I don't think that information is captured in the Audit database. All it sees are incoming requests, and I doubt there is anything in the request that identifies it originated in an MS office document.

Cheers!

MF.
Meep!

Andrew Weiss

Cognos office runs its queries against RDS (report data service) which is what the mashup service is built upon I believe. If you can enable logging on this service than you might be able to focus on the cognos office users. I seem to recall that the audit database logs what service is issuing the request. It's worth seeing if report executions from cognos office log in the audit database as Report Data Service.

Andy.


Sent from my iPhone using Tapatalk
MetaManager makes administering IBM Cognos a breeze.  http://www.bspsoftware.com/MetaManager