Hi Geoff,

Try this.

Select
client_schedules.schedule_name,client_schedules.action,client_schedules.star
ttime,associations.node_name -
from client_schedules,associations

Regards,

Stephen

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Gill, Geoffrey L.
Sent: Thursday, 28 September 2006 08:25
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] sql request

I was wondering if someone had a sql statement for this. I would like to
query the server to dump out the backup schedule name, action, start time
and the clients associated with each schedule.



Thanks,



Geoff Gill

TSM Administrator

PeopleSoft Sr. Systems Administrator

SAIC M/S-G1b

(858)826-4062

Email:  <mailto:geoffrey.l.gill AT saic DOT com> geoffrey.l.gill AT saic DOT com