Take a look at some of the existing report SQL scripts. Here's the related code from the hourly monitor CSM value:
scheduled_start between '%s' and '%s' Lots of good information can be found by looking at the scripts provided by TOR. Bill Boyer "A life? Cool! Where can I download one of those?" - ?? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Steven Harris Sent: Wednesday, January 17, 2007 1:07 AM To: ADSM-L@VM.MARIST.EDU Subject: 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
