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
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