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
Tim Brown wrote:
How can I tell which TSM tape volumes contain
backup data for a particular node
"QUERY NODEDATA node-name" will do the trick.
--
-- Skylar Thompson ([EMAIL PROTECTED])
-- Genome Sciences Department, System Administrator
-- Foege Building S048, (206)-685-7354
-- University of
