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/[EMAIL PROTECTED]
Internet e-mail: [EMAIL PROTECTED]
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@VM.MARIST.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:[EMAIL PROTECTED]> [EMAIL PROTECTED]
