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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Gill, Geoffrey L.
Sent: Thursday, 28 September 2006 14:12
To: ADSM-L AT VM.MARIST DOT 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: geoffrey.l.gill AT saic DOT com
-----Original Message-----
From: owner-adsm-l AT VM.MARIST DOT EDU [mailto:owner-adsm-l AT VM.MARIST DOT
EDU] On
Behalf Of Stephen Mackereth
Sent: Wednesday, September 27, 2006 4:47 PM
To: ADSM-L AT VM.MARIST DOT 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: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
|