Re: [Networker] mminfo question

I use an awk script to add up the 'totalsize(14)' field 

this example is to separate my many terabytes of the VTL pool into about
2 TB chunks - but it gives you the idea

first I do the mminfo command and sort by host:


mminfo -a -q "pool=VTL" -q "copies=1" -r
"ssid,ssflags,client,sscreate,ssbrowse,ssretent,totalsize(14),level,name
" | sort -ub +2 +0 | grep -v " vr" | grep -v " ssid      ssflags client
created  browse   retent           total  lvl name" | awk -f
~/bin/sizeclone.awk


and here's the sizeclone.awk:

BEGIN { { a = 1 } 
        { tot = 0 }
        { sets = 0 }
    { totsets = 1 } }
{ if ( a == 1 ) {
        print "cloneset ", a++ ," starts after ", $1 , $3 , $9 } }
{ s = s + $7 }
{ print $1 }
{ sets ++ }
{ if ( s >= 2048779069440 ) {
    print "      ( ", sets ," savesets, data size ", s/1099511627776 ,
"TB )"
    print "cloneset ", a++ ," starts after ", $1 , $3 , $9 
    tot = tot + s
    totsets = sets + totsets
    sets=0
    s=$7 } }
END { 
    print "      ( ", sets ," savesets, data size ", s/1099511627776 ,
"TB )"
    tot = tot + s
    totsets = sets + totsets - 1
    print "\nTotals: savesets", totsets, ", clonesets", a-1, ", data
size", tot/1099511627776 , "TB" }


hth
jerry

-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of William Fennell
Sent: Tuesday, October 31, 2006 3:10 PM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: [Networker] mminfo question

Hi,

I need to compile some information on my Solaris 9 Networker 7.2 server.
I need to know for a given date how much data was backed up to each
client.
Right now i run this command:
mminfo -r "savetime,sumsize,client" -q 
"pool=Default,savetime>=10/23/06,savetime<=10/24/06"

However I need the output in GB and totaled for each machine not broken 
down by save set.
The above command produces this mess:

 date      size client
10/23/06 8735 MB fermat
10/23/06 8260 MB fermat
10/23/06 3010 MB fermat
10/23/06 9044 MB fermat
10/23/06 240 MB jordan
10/23/06 3541 MB jordan
10/23/06 5455 MB jordan
10/23/06  22 GB nfssrv1
10/23/06  24 GB nfssrv1
10/23/06  11 GB nfssrv1
10/23/06 144 MB nfssrv1
10/23/06  62 MB nfssrv1
10/23/06  68 MB fermat
10/23/06 3058 MB fermat
10/23/06 2945 MB fermat
10/23/06 2318 MB fermat
10/23/06 2789 MB fermat
10/23/06 2633 MB fermat
10/23/06 4456 MB franklin
10/23/06 4509 MB jordan
10/23/06 4211 MB jordan
10/23/06 4334 MB jordan
10/23/06 922 MB jordan
10/23/06 2255 MB jordan
10/23/06   4  B darth
10/23/06 197 MB mayflower
10/23/06  24 KB bartok
10/23/06   4  B capecod
10/23/06  79 MB coffee
10/23/06  27 MB darth
10/23/06   4  B darth
......cut short for readability

It goes on and on.  Any tips would be greatly appreciated.

Thanks,

Bill

-- 
William Fennell
UNIX Administrator
Channing Laboratory

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