Re: [Networker] Querying tapes in the library

On Wed, Oct 24, 2007 at 08:57:10AM -0400, MIchael Leone wrote:
> I see. So now I have:
> 
> mminfo -q "near,%used>0" -r pool,volume,volaccess(22)

:-)  Feel free to add a '-av' to that report... Really. :-)

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

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

The mminfo page suggests that the 't' order flag will sort by last
access time in a media-only report (which is what you have).  The others
do not appear to be selectable.

     -o order
[...]
                                                             When
          applied to -m media-only reports,  the  length  is  the
          amount  used  on  the volume, the time is the last time
          the media was accessed, and the other order  flags  are
          ignored.

> I'd have to pipe the output to a sort command of some sort? Or am I
> misunderstanding the "-o" output option of mminfo?

Maybe it's some bad experiences with older versions, but I'll almost
always do that anyway.  I remember some very underpowered servers would
take a *long* time to re-sort the data, and I could do it in perl much
more quickly and with less load on the server.  The sorting problems may
be resolved in current versions, but I still don't use it.

-- 
Darren Dunham                                           ddunham AT taos DOT com
Senior Technical Consultant         TAOS            http://www.taos.com/
Got some Dr Pepper?                           San Francisco, CA bay area
         < This line left intentionally blank to confuse you. >

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