Thanks Stephen. When I run this it seems to show that every client I have is assigned to every schedule on the server, and I know that is not the case.
Geoff Gill TSM Administrator PeopleSoft Sr. Systems Administrator SAIC M/S-G1b (858)826-4062 Email: [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Mackereth Sent: Wednesday, September 27, 2006 4:47 PM To: [email protected] Subject: Re: sql request 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]
