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 >>> [EMAIL PROTECTED] 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 annotations on 06/05/02 11:33:59 ------------------------------------------------------------------------------ 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. ==============================================================================
