Hi, ref:

> From:    "William F. Colwell" <bcolwell AT DRAPER DOT COM>
> Bruce, The tsm or automatically provides a 24 hour time range in the
> sql it generates and sends to the server.  So you will automatically
> get a report for the 24 hours prior to the start time. To
> experiment, define your report and right click on it, select
> 'refresh with the scheduled time'. Hope this helps, Bill Colwell
>
> At 11:18 AM 2/20/2004, you wrote:
>Trying to setup a new report.  What I can't figure out how to do is
>specify in the query to use the time I have requested.  I have it set
>to time start 5:30AM Hours covered 24. Thanks, Bruce Kamp

As Bill said TSMOR can dynamically insert time parameters when the
report is run.  For more information see the TSMOR 5.2.2 readme file
(tsmrept_readme.txt) in the console directory and search for "How to
use variables in select statements"

Regards,

Mike Collins
Tivoli Storage Product Architecture
emcollin AT us.ibm DOT com