Try this command...

 select distinct node_name,volume_name from volumeusage where node_name
='Node_name'

Sung Y. Lee
sunglee AT us.ibm DOT com


                                                                                
                                                         
                    Christoph Pilgram                                           
                                                         
                    <[email protected]       To:     ADSM-L 
AT VM.MARIST DOT EDU                                             
                    LHEIM.COM>                                  cc:             
                                                         
                    Sent by: "ADSM: Dist Stor Manager"          Subject:     
AW: tapes for nodes                                         
                    <ADSM-L AT VM.MARIST DOT EDU>                               
                                                                
                                                                                
                                                         
                                                                                
                                                         
                    09/20/2001 10:29 AM                                         
                                                         
                    Please respond to "ADSM: Dist Stor                          
                                                         
                    Manager"                                                    
                                                         
                                                                                
                                                         
                                                                                
                                                         



Try "show volumeusage *  "

> -----Ursprüngliche Nachricht-----
> Von:  Jeff Bach [SMTP:jdbach AT WAL-MART DOT COM]
> Gesendet am:  Donnerstag, 20. September 2001 16:01
> An:   ADSM-L AT VM.MARIST DOT EDU
> Betreff:
>
> All,
>
>         I need some quick help,   I need the show command that shows all
> tapes that contain data for a particular node.
>
>         Can anyone help?
> Jeff Bach
> Home Office Open Systems Engineering
> Wal-Mart Stores, Inc.
>
> WAL-MART CONFIDENTIAL
>
>
>
> **********************************************************************
> This email and any files transmitted with it are confidential
> and intended solely for the individual or entity to
> whom they are addressed.  If you have received this email
> in error destroy it immediately.
> **********************************************************************