I don't see any way to get that. The TSM server stores the backup date of a file in the BACKUPS table.
But there is no pointer to tell you which storage pool volume that particular file is in. WHY are you trying to get the information? Perhaps there is another way. If you have the file 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 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