Re: select statemant to find oldest file in diskpool

2006-12-29 Thread Kerry Campbell
--Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Prather, Wanda Sent: Friday, December 29, 2006 10:52 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] select statemant to find oldest file in diskpool I don't see any way to get that. The TSM server stores

Re: select statemant to find oldest file in diskpool

2006-12-29 Thread Prather, Wanda
name, just pull it from the backups table... -Original Message- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Gary Osullivan Sent: Friday, December 29, 2006 11:30 AM To: ADSM-L@VM.MARIST.EDU Subject: select statemant to find oldest file in diskpool hi all I'm

select statemant to find oldest file in diskpool

2006-12-29 Thread Gary Osullivan
hi all I'm trying to come up with an sql to select the file dates in a specific stgpool What I really need to find is the oldest date stamp of a file in a specific onsite disk pool any help would be great Gary