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

How to find the last time a report is viewed

Started by Jaspire, 30 Apr 2008 05:29:47 PM

Previous topic - Next topic

Jaspire

Hi,
We need to delete the unused Reports and archive them. Is there any way to find when a report is viewed last time?
Thanks,
Madhavi

almeids

Read up on auditing and turn it on if it isn't already.

Jaspire


Thank you for your reply. I will surely read on auditing and will turn it on. But is there any way I can know which reports were not viewed from certain period of time?
Thanks again,
Jaspire

almeids

Yes, once you've turned on auditing.  Or you may be able to trawl though log files, very impractical assuming you even keep them around as long as you need to look back.  Can't give you advice there as it's been too long since I've dealt with them (and never in C8).

Jaspire


Thanks almeids,

Actually auditing is turned on long before. Now I see that there is an audit database in SQL Server. How can I find the reports that were not viewed since a certain time. Also I am wondering if its enough if I just look for the last run time of a report? or should I look for last viewed time? Does a saved report reflect the latest data in the database or not? I think its enough if we take the last run time in consideration when archiving. But I was asked to find last viewed time. Does that make any difference?
Thanks,
Jaspire

avitabj

H!  The table cogipf_viewreport is populated when a user views the report.  There's a timestamp so you could look for the max(cogipf_localtimestamp) for the report.  Both the search path and report name are in the table.

Early versions of ReportNet did not handle this table properly so you should be on at least 7.3.

hth...jean

Jaspire

Thanks for your reply,
I found that there are so many reports which are not used anymore. Can you suggest a way for me so that I can archive all the unused reports at once, instead of sending each report into Archive?
Thanks again,
Jaspire

avitabj

Do you have the SDK?   From the cogipf_viewreport table, you can create a file of the search paths of the reports to be archived.  Then use the SDK to archive the report xml to disk and then delete the report.

hth...jean

Jaspire


Thanks,
No we don't have SDK. Can we use Content Store database and write some sort of VB program to move the reports which we see in Audit database to some Archive folder?
I appreciate if you could give me any information on Content store.
Jaspire