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.
> > >
> >
>
|