Hi Geoff, Oops! I tested on our small tsm server and it worked (accidently)
Try this instead. select client_schedules.schedule_name,client_schedules.action,client_schedules.star ttime,associations.node_name - from client_schedules,associations where client_schedules.schedule_name=associations.schedule_name Regards, Stephen. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gill, Geoffrey L. Sent: Thursday, 28 September 2006 14:12 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] sql request 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: ADSM-L@VM.MARIST.EDU 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: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED]> [EMAIL PROTECTED]