No and no.

The closest you can get is something like this:
"select distinct node_name, volume_name, copy_type, stgpool_name from
volumeusage where node_name='X' and filespace_name='Y'"
Add "and volume_name not in(select volume_name from libvolumes)" and use
copy_type and stgpool_name to narrow your results if you like.

//Henrik





                    Karin Dambacher
                    <karin.dambacher@E        To:     ADSM-L AT VM.MARIST DOT 
EDU
                    MPRISE.DE>                cc:     (bcc: Henrik Wahlstedt)
                    Sent by: "ADSM:           Subject:     Programmes Guide
                    Dist Stor Manager"
                    <[email protected].
                    EDU>


                    14.04.2005 14:07
                    Please respond to
                    "ADSM: Dist Stor
                    Manager"






Hi all,

does anyone know, where to find online (the) a TSM programmer's guide?
Is there a possiblity to get a list of tapes, where are a client's data ?
Not all tapes (I know this select), but if I want to do a "restore
c:\home" only the tapes I need for that restore?

Thanks for every help, regards, Karin Dambacher




-------------------------------------------------------------------
The information contained in this message may be CONFIDENTIAL and is
intended for the addressee only. Any unauthorised use, dissemination of the
information or copying of this message is prohibited. If you are not the
addressee, please notify the sender immediately by return e-mail and delete
this message.
Thank you.