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:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: Thursday, 28 September 2006 08:25 To: [email protected] 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:[EMAIL PROTECTED]> [EMAIL PROTECTED]
