This *might* do what you need. Initial testing suggests it works. Caveats:
I guarantee nothing :-) and it will probaby take a while to run (mine took
about 15 minutes). Try it and see; look at the tables separately and make
sure the output you get looks correct. My main concern is that this still
might not filter out all duplicates, but my basic testing on a moderate
server didn't show any duplicates.

Note: you said you wanted start time, but I'm not sure if you mean the
schedule definition start time or the event start time. For the latter,
you'd need to add the events table into the mix.

select c.domain_name, \
       c.schedule_name, \
       action, \
       startdate, \
       starttime, \
       duration, \
       durunits, \
       period, \
       perunits, \
       n.node_name, \
       platform_name \
   from client_schedules c, nodes n, associations a \
   where c.domain_name=a.domain_name and \
         c.schedule_name=a.schedule_name and \
         n.node_name=a.node_name

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-10-13
13:13:11:

> Hello all,
>
> I'm wondering if anyone has a query for this. Something broken out by
> schedule name with the nodes associated with each schedule. I'm looking
for
> schedule name, Action, Date/Time, Period and Duration, Platform and the
node
> names associated with each schedule.
>
>
>
> Thanks,
>
>
>
> Geoff Gill
>
> TSM Administrator
>
> SAIC M/S-G1b
>
> (858)826-4062
>
> Email:  <mailto:geoffrey.l.gill AT saic DOT com> geoffrey.l.gill AT saic DOT 
> com