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

 

Audit Report for Deleted Reports from Cognos Connection

Started by Srik, 15 Oct 2009 12:57:12 PM

Previous topic - Next topic

Srik

Hi.

I'm trying to build a Audit report using Audit tables the purpose of the report is to find deleted or Renamed Reports from original Report name in Cognos Connection.
I'm wondering if there is any kind of indicator field in Audit table from which i can get details of the above reports.

Thanks in Advance.
Kanth

Srimurugan

Replying it for an old post. But this would help some one searching for a query to identify who deleted/updated the reports in cognos connection . Use this below query in cognos 10 Audit DB.

select * from [dbo].[COGIPF_ACTION] where COGIPF_OPERATION in ('DELETE','UPDATE') AND COGIPF_TARGET_TYPE = 'FOLDER' AND COGIPF_TARGET_PATH like '%/Public Folders%'
AND COGIPF_LOCALTIMESTAMP BETWEEN '2014-05-01' and '2014-05-31' ORDER BY COGIPF_LOCALTIMESTAMP desc

get the session ID COGIPF_SESSIONID from above query and find the actual user by passing to this table COGIPF_USERLOGON

join these tables to get the user directly. have some hands on and fun :-)

Enjoy.

Thanks,
Sri