Hello Mark !

That command works well, but I need the tapes where only the backupactive
data is on.

Oli



             "Stapleton, Mark"
             <mark.stapleton@B
             ERBEE.COM>                                                 An
             Gesendet von:               ADSM-L AT VM.MARIST DOT EDU
             "ADSM: Dist Stor                                        Kopie
             Manager"
             <[email protected]                                       Thema
             .EDU>                       Re: Export Nodes which Tape di I
                                         need

             06.05.2004 15:03


              Bitte antworten
                    zu
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .EDU>



             Kundennr.:





>From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
Of
>Oliver Martin
>>I have more tapes than my library has slots and that is why I must
>checkin libv during the process export node, filedata=backupactive, I
do >>every weekend. When I do an preview export node I there is no
option which
>>tells me which tapes the export needs for completition.

From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Stapleton, Mark
>select distinct volume_name from volumeusage where
>node_name='DESIRED_NODE'
>
>(The node name must be in single quotes and capitalized.)

Let me correct that command:

select distinct volume_name from volumeusage where
node_name='DESIRED_NODE' and stgpool_name='PRIMARY_TAPE_STORAGE_POOL'

This way, you'll only see the volume names from the primary (in-library)
storage pool.

--
Mark Stapleton