On 5 Jun 2002 at 11:18, David Longo replied, in part:
> select node_name,filespace_name,class_name from backups
> where node_name='NODE' and filespace_name='FSNAME'.

You might want to change /class_name/distinct(class_name)/.

But then, while there is a default (and perhaps other) management
class(es) for files in a file space, a file space does not "belong" to
a management class.  Do you want to know the default management class
for a file in a file space or the management class for a particular
backed up object?    cheers, wayne

Wayne T. Smith                          ADSM AT Maine DOT edu
ADSM Technical Coordinator - UNET       University of Maine System