Re: [Networker] mminfo Report Help

You can query and parse ssflags (look for flag "I")

eg :
        
for each SSID on `mminfo -q "savetime > 1 day ago" -r ssid,ssflags |
grep I`
do
        mminfo -s ssid=$SSID -r "client,name,sscreate(22),level"
done

        
or query on "incomplete" flag

mminfo -q "savetime>1 day ago, incomplete" -r
"client,name,level,sscreate(22)"


HTH

TH



Kind regards - Bien cordialement - Vriendelijke groeten,

Thierry FAIDHERBE

HP Services - Storage Division
Tru64 Unix and Legato Enterprise Backup Solutions Consultant
                                   
 *********       *********   HEWLETT - PACKARD
 *******    h      *******   1 Rue de l'aeronef/Luchtschipstraat
 ******    h        ******   1140 Bruxelles/Brussel/Brussels
 *****    hhhh  pppp *****   
 *****   h  h  p  p  *****   100/102 Blv de la Woluwe/Woluwedal
 *****  h  h  pppp   *****   1200 Bruxelles/Brussel/Brussels
 ******      p      ******   BELGIUM
 *******    p      *******                              
 *********       *********   Phone :    +32 (0)2  / 729.85.42   
                             Mobile :   +32 (0)498/  94.60.85 
                             Fax :      +32 (0)2  / 729.88.30   
     I  N  V  E  N  T        Email/MSN : thierry.faidherbe(at)hp.com
                             Internet  : http://www.hp.com/ 
-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Andrew Dietz
Sent: Monday, January 22, 2007 4:11 PM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] mminfo Report Help

I am looking for a way to produce a report via the command line that 
lists any saves that are still currently running. I can list all saves 
for a particular host that will show any unfinished saves with the 
sscomp field set to 'undefined', but I can't seem to be able to query by

sscomp=undefined.

mminfo -vr 'ssflags,client(20),name(30),level,savetime(20),sscomp(20)' \


    -q "client=myhost"

vF  myhost /cyrus/mail  incr 01/15/07 19:00:06  01/17/07 04:02:39
vF  myhost /cyrus/mail  incr 01/17/07 19:00:04  01/21/07 02:19:10
viI myhost /cyrus/mail  incr 01/21/07 19:00:24  undefined

but:

mminfo -vr 'ssflags,client(20),name(30),level,savetime(20),sscomp(20)' \


    -q "sscomp=undefined"

mminfo: invalid value specified for `sscomp'

How can I construct this query to where I can generate a report that 
shows all hosts whose saves are still running, such that my result would

appear something like:


viI myhost01 /cyrus/mail  incr 01/20/07 19:00:24  undefined
viI myhost03 /home        incr 01/21/07 17:00:32  undefined
viI myhost09 /usr         incr 01/21/07 20:00:45  undefined
viI myhost12 /opt         incr 01/22/07 20:00:24  undefined

or something similar?

Thanks in advance for your help.

Andrew

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

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