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

Author Topic: How to find the last time a report is viewed  (Read 15368 times)

Jaspire

  • Guest
How to find the last time a report is viewed
« on: 30 Apr 2008 05:29:47 pm »
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

  • Guest
Re: How to find the last time a report is viewed
« Reply #1 on: 01 May 2008 06:54:55 am »
Read up on auditing and turn it on if it isn't already.

Jaspire

  • Guest
Re: How to find the last time a report is viewed
« Reply #2 on: 01 May 2008 07:15:09 am »

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

  • Guest
Re: How to find the last time a report is viewed
« Reply #3 on: 01 May 2008 10:42:03 am »
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

  • Guest
Re: How to find the last time a report is viewed
« Reply #4 on: 01 May 2008 05:27:01 pm »

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

  • Guest
Re: How to find the last time a report is viewed
« Reply #5 on: 05 May 2008 07:10:21 am »
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

  • Guest
Re: How to find the last time a report is viewed
« Reply #6 on: 05 May 2008 07:52:40 am »
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

  • Guest
Re: How to find the last time a report is viewed
« Reply #7 on: 06 May 2008 06:10:51 am »
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

  • Guest
Re: How to find the last time a report is viewed
« Reply #8 on: 06 May 2008 02:46:15 pm »

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