Networker

Re: [Networker] Querying tapes in the library

2007-10-24 09:00:40
Subject: Re: [Networker] Querying tapes in the library
From: MIchael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 24 Oct 2007 08:57:10 -0400
EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU> wrote on 
10/23/2007 04:12:48 PM:

> On Tue, Oct 23, 2007 at 03:49:31PM -0400, MIchael Leone wrote:
> > I'd like to run a report that shows me all the tapes currently in the 
> > library slots that have a used percentage > 0, and I'd like to see the 

> > volume ID, pool, last access date and time. But it seems like mminfo 
won't 
> > allow me to specify the report criteria to print (unless I'm totally 
> > missing something, which is entirely likely), when I'm querying media 
in 
> > the library, as opposed to media in the media database.
> 
> Hm..  All media in the library should be in the media database, so it's
> the same thing.  You would just be limiting the set to items in the
> jukebox (or all nearline storage which could be in any jukebox).
> 
> > C:\PHA Scripts>mminfo -q "near,%used>0" -m
> >  state volume                  written  (%)  expires     read mounts 
> > capacity
> >        915613                    14 GB   9% 12/23/2007   0 KB    23 
160 
> > GB
> > 
> > I can't add any "-r" specs to the mminfo command. Can anybody re-point 
me 
> > in the right direction to get what I want?
> 
> -m is just an implicit report spec.  You can't use it and an explicit
> report.  Just drop the '-m'.

CLICK! (that was the lightbulb turning on)

I see. So now I have:

mminfo -q "near,%used>0" -r pool,volume,volaccess(22)

 pool          volume               vol access
REMOTE         01036616        10/24/2007 1:08:17 AM
PHAPRD         1127153518     10/23/2007 11:57:06 PM
PHACLONE       1127153623      10/24/2007 4:18:24 AM
PHACLONE       1127153624      10/24/2007 3:02:14 AM
PHAPRD         896587          10/24/2007 5:22:38 AM
PHAPRD         897251          10/23/2007 7:33:32 PM
PHACLONE       897540          10/24/2007 2:04:06 AM
Bootstrap      915613         10/23/2007 10:14:44 AM
PHACLONE       915682           8/18/2007 2:26:11 AM
PHAPRD         915744          10/24/2007 5:09:45 AM


which is pretty much what I want (those were the tapes used last night, 
with the exception of the one tape I forgot to relabel, so that it's 
percent used would be set back to zero). Am I correct that there is no 
(NetWorker) way to sort the output by pool, volume, last access time? I'd 
have to pipe the output to a sort command of some sort? Or am I 
misunderstanding the "-o" output option of mminfo?

Thanks; that was a big help, actually. :-)

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER