Adding new reports to TSMOR

Hi all,

I've tried looking for detailed info on TSMOR but haven't been able to
find anything.  Google, redbooks, quickfacts have nothing  Very
frustrating.
I'm trying to add a new report to TSMOR reporting.  I've worked out the
sql that I want and run it with reasonable success.

The problem I'm having is how to get TSMOR to substitute in the start
and end times.
for example, one of the standard reports runs
select domain_name, schedule_name, node_name,
  substr(char(scheduled_start), 1, 16) as "SCHEDULED_START",
  substr(char(actual_start), 1, 16) as "ACTUAL_START",
  status, result
from events
where (scheduled_start between '2007-01-16 14:50:29'
  and '2007-01-17 14:50:28') and LENGTH(domain_name) IS NOT NULL order
by scheduled_start,status,result

The "scheduled_start between" clause  is inserted by TSMOR when the
report is generated.

Does anyone know how to do this for my own SQL?


Thanks

Steve

Steve Harris
AIX and TSM Admin
Brisbane Australia