Re: Reporting Tool - Elapsed Time

A schedule can be associated with multiple nodes. Hence, one can rather
attempt 
SELECT * FROM SUMMARY which may be filtered on SCHEDULE_NAME or
ENTITY(node) and the elapsed time may be calculated using the start_time
and end_time.

Or

Try processing the ANR2507I message from actlog:

ANR2507I Schedule (schedule name) for domain (domain name) started at
start
(timestamp) for node (node name) completed successfully at (timestamp).


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Dksh Cssc
Sent: Thursday, February 09, 2006 6:21 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Reporting Tool - Elapsed Time


Hi all,

I would like to retrieve the elapsed time that is associated to a
particular schedule. However when I issue the command "Select * from
actlog". The schedname is blank. So how could I have the schedule name
display when i re-issue the same command? How could I manipulate the
database part?

DATE_TIME: 2006-01-10 00:00:06.000000
     MSGNO: 403
  SEVERITY: I
   MESSAGE: ANR0403I Session 26167 ended for node KULDB01C_RT
(RealTime).
(SESSION: 26167)
ORIGINATOR: SERVER
  NODENAME:
 OWNERNAME:
 SCHEDNAME:
DOMAINNAME:
    SESSID:
SERVERNAME:
   SESSION: 26167
   PROCESS:

Thanks
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the sender, 
delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------