Seems to be ok but unless I can run it on production I won't know for sure.
The question now is how to get this to read in columns by nodename instead.
Sorry if this is simple to others but I have no experience with these.

  DOMAIN_NAME: NT_DOM
SCHEDULE_NAME: CLIENT2_M-F
       ACTION: INCREMENTAL
    STARTDATE: 2000-12-18
    STARTTIME: 22:30:00
     DURATION: 1
     DURUNITS: HOURS
       PERIOD: 1
     PERUNITS: DAYS
    NODE_NAME: CP-ITS-MRP01
PLATFORM_NAME: WinNT

Thanks,

Geoff Gill
TSM Administrator
SAIC M/S-G1b
(858)826-4062
Email: geoffrey.l.gill AT saic DOT com



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Andrew Raibeck
Sent: Friday, October 14, 2005 9:06 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Query for schedule and node

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/IBMTivoliStorageMan
ager.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