select node_name,filespace_name,class_name from backups
where node_name='NODE' and filespace_name='FSNAME'.

Node has to be all UPPER CASE and filespace_name may be all
UPPER or mixed depending on platform etc.

This can give long display if lot of files in  filespace, I think
there is a SQL way to shorten but this will give you the basics.

David Longo

>>> justin.bleistein AT SUNGARD DOT COM 06/05/02 11:00AM >>>
Does anyone know how to tell what management class a filespace belongs too
from the server side? Is there a select or a query command?

--Justin Richard Bleistein
"MMS <health-first.org>" made the following
"MMS <health-first.org>" made the following
 annotations on 06/05/02 11:33:59
------------------------------------------------------------------------------
---
This message is for the named person's use only.  It may contain This message 
is for the named person's use only.  It may contain confidential, proprietary, 
or legally privileged information.  No confidentiality or privilege is waived 
or lost by any mistransmission.  If you receive this message in error, please 
immediately delete it and all copies of it from your system, destroy any hard 
copies of it, and notify the sender.  You must not, directly or indirectly, 
use, disclose, distribute, print, or copy any part of this message if you are 
not the intended recipient.  Health First reserves the right to monitor all 
e-mail communications through its networks.  Any views or opinions expressed in 
this message are solely those of the individual sender, except (1) where the 
message states such views or opinions are on behalf of a particular entity;  
and (2) the sender is authorized by the entity to give such views or opinions.

==============================================================================