Find out when a report was last run?

[sdrzewiczewski]

Is there a way to determine the last time a report was run? We are looking to clean up some legacy reports that are no longer used and was wondering if there was a way to find out when a report was last run. Not sure if this information gets stored back in the db or not.

Thanks,

Steve D.

[MikeLockwood]

Our normal way of approaching these things (ha ha) is to disable or hide or rename them and just wait to see who screams "where's my stuff." Not so elegant but very effective. This idea mainly from a very wise man who sits two desks from me.

[ddemay]

No there is nothing stored in db perhaps you could use apache access logs or create a tomcat filter to monitor hits on these. Apache should do the trick. A simple log monitor for a string pattern or if you rotate logs etc. And you could search for the request initiating the report gen.

Dave


Sent from my Verizon Wireless BlackBerry

[sdrzewiczewski]

Excellent.



Thanks for the suggestion!

[jtjohnson]

I haven't checked, but I would think it would show up in the Method
Server log, if not by default, probably with the proper verbose setting
on.



Jeff

[jessh]

There is nothing "out of the box" for this.

That said, in R9.x there already is a servlet filter that can do
extensive monitoring and logging of servlet requests -- controlled by
the ServletRequests MBean (see the JMX and MBean material in the System
Configurator's Guide). In recent versions/MORs one can also add a
FilteredLogger instance (there's one already there out-of-the-box you
can use in these versions) to log only specific request URI patterns.

Of course, you can't go back in time to enable such logging for the last
'n' months.

--
Jess Holle

> No there is nothing stored in db perhaps you could use apache access
> logs or create a tomcat filter to monitor hits on these. Apache should
> do the trick. A simple log monitor for a string pattern or if you
> rotate logs etc. And you could search for the request initiating the
> report gen.
>
> Dave
>
> Sent from my Verizon Wireless BlackBerry
>

[KevinAlexander]

Always better to ask for forgiveness than permission!

From: Lockwood,Mike,IRVINE,R&D [