Use the following : select distinct volume_name from volumeusage where node_name='SERVERNAME'
SERVERNAME should all be in uppercase . Rich -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Tim Brown Sent: Tuesday, January 29, 2008 11:33 AM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] What volumes contain node backup data How can I tell which TSM tape volumes contain backup data for a particular node Tim Brown Systems Specialist - Project Leader Central Hudson Gas & Electric 284 South Ave Poughkeepsie, NY 12601 Email: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Phone: 845-486-5643 Fax: 845-486-5921 Cell: 845-235-4255 Standard Life : 175 ans au coeur de nos vies Standard Life: Part of our lives for 175 years