Chris

There is a table in the database called volumeusage.  A sample output is
shown below.

adsm> SELECT * FROM VOLUMEUSAGE WHERE NODE_NAME='TSG_PDC'

     NODE_NAME: TSG_PDC
     COPY_TYPE: ARCHIVE
FILESPACE_NAME: \\tsg_pdc\d$
  STGPOOL_NAME: MFSERVICES_3494
   VOLUME_NAME: AA9172

To establish which volumes are used by a particular node and stgpool we use
something like the following.

adsm> select distinct volume_name from volumeusage where
node_name='PR005052A' AND STGPOOL_NAME='NHHDA_3494'


VOLUME_NAME
------------------
A11023
A11023
A11025
A11028
A11033
A11035
A11036
A11051
A11056

Hope this helps.

Richard.



=====================================
Technical Services (ADSM) - Dawson House
Int: 33298  Ext: 01925 233298
=====================================

> -----Original Message-----
> From: Jordan, Chris (ELS) [SMTP:c.jordan AT ELSEVIER.CO DOT UK]
> Sent: 08 October 1999 09:32
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Which tapes??
>
> Given a node or a file space, how can I find out which tapes (on-site
> primary and off-site copy) have data on them for that node??
>
> Cheers, Chris
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************