Try the following:
select volume_name from volumeusage where node_name='adsmnodename' and 
filespace_name='filespacename'
(Column and table names are from ADSM for NT, names may be different
for other platforms.

Roberts, Scott wrote:
>
> "SHOW VOLUMEUSAGE node" is almost what I need. If there was a way of
> limiting the
> output to report on a specific filespace (filesystem), that would be
> perfect. The problem I'm having is
> that the filespace I have to restore a spread amongst 55 8mm cartridges. My
> tape library
> can only hold 10 at a time. If I knew which volumes the filesystem
> (filespace) was on,
> I could load the library with just those volumes, or the first ten, then
> start the restore and go home.
> What I have to do now is wait for ADSM to tell me which volume to mount next
> as it's restoring.
> I believe LEGATO has such a feature.
>
> > -----Original Message-----
> > From: Jerry Lawson [SMTP:jlawson AT THEHARTFORD DOT COM]
> > Sent: Wednesday, April 01, 1998 7:49 AM
> > To:   ADSM-L AT VM.MARIST DOT EDU
> > Subject:      Can I preview a restore of a filesystem
> >
> > ---------------------------- Forwarded with Changes
> > ---------------------------
> > From: owner-adsm-l (INTERNET.OWNERAD) at SNADGATE
> > Priority: Urgent
> > Date: 3/31/98 11:42PM
> > To: Jerry Lawson at ASUPO
> > Subject: Can I preview a restore of a filesystem
> > --------------------------------------------------------------------------
> > -----
> > The following works on a V2 MVS server, so I would expect that it would
> > work
> > on an AIX one.... (but no guarantees) :-)>
> >
> > The only way that I know of to determine what tapes are needed is via an
> > undocumented command:
> >
> >      SHOW VOLUMEUSAGE node
> >
> > Beware, this is not a fast command - I suppose it depends on the size of
> > your
> > DB.  The command will show you which tapes a node is using.  It will only
> > include backups (not archive), and it is for all file systems.  It does
> > not
> > actually move any data, or ask for any mounts.
> >
> > There is no way that I am aware of to preload files from tape back to the
> > storage pool.  You could use the Move Data command, but that would take
> > all
> > of the files from the tape, so it is not very discriminating.
> >
> > Jerry Lawson
> > jlawson AT thehartford DOT com
> >
> >
> >
> >
> >
> > ______________________________ Forward Header
> > __________________________________
> > Subject: Can I preview a restore of a filesystem
> > Author:  owner-adsm-l (INTERNET.OWNERAD) at SNADGATE
> > Date:    3/31/98 11:42 PM
> >
> >
> > I will be restoring a filesystem which had been incrementally backed up
> > over
> > time
> > to an exabyte tape library unit. I would like to pre-load all the volumes
> > necessary for the
> > restore of a filesystem before starting the restore. Is there a way to
> > "preview" the restore
> > to determine which volumes will be needed ???
> >
> > Environment
> > AIX4.2
> > ADSM 2.1.12 (server)
> > ADSM 2.1.0.3 (client)
> > Exabyte has 10 slots, one drive and very slow and old.