ADSM-L

select statement similar to query client schedules

2003-03-19 07:14:55
Subject: select statement similar to query client schedules
From: Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Wed, 19 Mar 2003 07:13:59 -0500
Hello everyone!

I have a user that would like the output of the query the schedule event
records for the users to be sorted in alphebetical order by the node name
instead of the start time of the output.  Is there a select statement that
can pull out the same info, but sort it by node name, actual start,
schedule name and status?  Thanks!

Scheduled Start      Actual Start         Schedule Name Node Name
Status
-------------------- -------------------- ------------- -------------
---------
03/18/2003 20:00:00  03/18/2003 20:17:59  DAILY_INCR2   HMCH1124
Completed
03/18/2003 20:00:00  03/18/2003 20:06:19  DAILY_INCR2   HMCH1125
Completed
03/18/2003 20:00:00  03/18/2003 20:16:23  DAILY_INCR2   HMCH1129
Completed

Joni Moyer
Systems Programmer
joni.moyer AT highmark DOT com
(717)975-8338

<Prev in Thread] Current Thread [Next in Thread>