Thanx, Joe & John --- this is quite cool... would be even nicer if we could
get just the list of tapes that are currently "NOT AVAILABLE" (ie, stored
outside the silo)... Can we do a join with the volumes table so select will
only display the unique volumes not in the silo???

Ultimately, one wants to do that *and* limit the query results to the files
that match a restore filespec pattern.  That's what...

         restore x:\...\xyz\...\* -preview=yes

might display, if we could get it -- IMHO.

Regards,
Don


Don France

Technical Architect, P.A.C.E.
San Jose, CA
mailto:dfrance AT pacbell DOT net
PACE - http://www.pacepros.com
Bus-Ph:   (408) 257-3037




> -----Original Message-----
> From: Joe Faracchio [mailto:brother AT socrates.Berkeley DOT EDU]
> Sent: Monday, July 10, 2000 1:10 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Query Volumes for a Restore
>
>
> I tried this and found adding 'distinct' and 'where
> stgpool_name='ONSITE'"
> ( or ='OFFSITE' )   help cut down the noise.
>
> as in:
>
> select distinct node_name,volume_name,stgpool_name from
> volumeusage where
> node_name='$1' and stgpool_name='ONSITE'
>
>              ... joe.f.
>
> Joseph A Faracchio,  Systems Programmer, UC Berkeley
>
>
> On Fri, 30 Jun 2000, Price, John wrote:
>
> > Try this,
> > select node_name,volume_name,stgpool_name from volumeusage where
> > node_name='$1'
> >
> > > ----------
> > > From:         France, Don (Pace)[SMTP:don.france-eds AT EDS DOT COM]
> > > Reply To:     ADSM: Dist Stor Manager
> > > Sent:         Friday, June 30, 2000 12:52 PM
> > > To:   ADSM-L AT VM.MARIST DOT EDU
> > > Subject:      Re: Query Volumes for a Restore
> > >
> > > I've looked far and wide (but not in the latest AIX
> package) for info re.
> > > the ba/client restore option "preview=yes"... cannot find
> any reference to
> > > it!  Are you sure this works for end-user, b-a client
> restore?!?  (I could
> > > probably construct a SELECT query to find the info, would
> be nice if
> > > restore
> > > had it!)
> > >
> > > TIA,
> > > Don
> > >
> > > Don France
> > >
> > > Technical Architect, P.A.C.E.
> > > San Jose, CA
> > > mailto:dfrance AT pacbell DOT net
> > > PACE - http://www.pacepros.com
> > > Bus-Ph:   (408) 257-3037
> > >
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: Roger C Cook [mailto:rcook AT ROTECH DOT COM]
> > > > Sent: Wednesday, June 28, 2000 11:08 AM
> > > > To: ADSM-L AT VM.MARIST DOT EDU
> > > > Subject: Re: Query Volumes for a Restore
> > > >
> > > >
> > > > Sorry, I wasn't aware of those limitations as I am on AIX and
> > > > do 95% of
> > > > my administration from the command line. Once again I
> give thanks that
> > > > I'm in a (predominantly) Unix shop.
> > > >
> > > > Roger C Cook
> > > > RCG Information Services
> > > >
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On
> > > > Behalf Of
> > > > Gerald Wichmann
> > > > Sent: Wednesday, June 28, 2000 12:54 PM
> > > > To: ADSM-L AT VM.MARIST DOT EDU
> > > > Subject: Query Volumes for a Restore
> > > >
> > > >
> > > > Doing a preview=yes is a good idea however there are two
> > > > problems with it..
> > > > The web GUI doesn't allow for preview=yes which isn't that
> > > > big a deal, you
> > > > can do a command line one temporarily.. But also NT doesn't
> > > > seem to have a
> > > > preview=yes switch. This means this technique doesn't work
> > > > for my given
> > > > situation..
> > > >
> > > > Surely there's another way.. some painful select query I'm
> > > > guessing..hmm..
> > > > Seems a useful feature to have.
> > > >
> > >
> >
>