select node_name from occupancy where filespace_name='/cagvsp1/entp/prod'
[EMAIL PROTECTED] "Cain, Jason (Corporate)" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 10/07/2004 09:32 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject select statement help What is the select statement to tell what node is backing up certain filespaces if the customer does not know the node name? The filespace is: /cagvsp1/entp/prod/ Thanks. Jason