Networker

Re: [Networker] reporting volumes on retention

2008-05-16 12:52:31
Subject: Re: [Networker] reporting volumes on retention
From: MIchael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Fri, 16 May 2008 12:49:25 -0400
-- 
Michael Leone
Network Administrator, ISM
Philadelphia Housing Authority
2500 Jackson St
Philadelphia, PA 19145
Tel:  215-684-4180
Cell: 215-252-0143
<mailto:michael.leone AT pha.phila DOT gov>


EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU> wrote on 
05/16/2008 12:18:40 PM:

> In regard to: [Networker] reporting volumes on retention, ianc said 
(at...:
> 
> > I need to cross charge for the amount of data held on retention at a 
per
> > GB rate. What I don't know, is to how to work out how much data we 
have
> > on retention? Hopefully, I don't need to go through the whole index - 
as
> > some of it is on tape itself, and it would probably take forever to do 
-
> > and I need to do it every month.
> 
> I'm not sure I understand what you're asking, but it sounds like you 
need
> to determine how much data one or more of your backup clients has backed
> up.
> 
> If that's the case, one place to start would be with the mminfo command.
> Look at the "totalsize" attribute.  For example:
> 
> $ mminfo -ot -q 'client=dogbert.cc.ndsu.nodak.edu' \
>     -r 'savetime,level,totalsize,nfiles' | head -n 10

You might want to try it as "totalsize(2)", which will list the size in 
GB, which is what you say you need.

mminfo -ot -r "ssid,cloneid,client,savetime(22),totalsize(2),nfiles" -q 
"client=admnlts003"

 ssid         clone id client         date     time      total nfiles
19625473    1210807808 admnlts003  5/14/2008 7:30:08 PM 2648 KB 18
4213929486  1210807821 admnlts003  5/14/2008 7:30:21 PM 4479 MB 25062
4247483905  1210807808 admnlts003  5/14/2008 7:30:12 PM 309 GB  15697
4230706689  1210807808 admnlts003  5/14/2008 7:30:13 PM 8927 KB 11
4281038337  1210807808 admnlts003  5/14/2008 7:30:10 PM 495 MB  2648
2848257     1210807808 admnlts003  5/14/2008 7:30:09 PM 19 MB   18
4264261121  1210807808 admnlts003  5/14/2008 7:30:11 PM 30 KB   12

> 
> To get the number you're looking for, just report totalsize and then add
> the numbers up using whatever method you like:
> 
> $ mminfo -ot -q 'client=dogbert.cc.ndsu.nodak.edu' \
>     -r 'totalsize(22)' | add-column.awk
> # of lines not matching: 0
> # of lines matching    : 2568
> # of lines total       : 2568
> Total of the lines     : 5.73645e+11
> 
> 
> Tim
> -- 
> Tim Mooney                                        Tim.Mooney AT ndsu DOT edu
> Information Technology Services                   (701) 231-1076 (Voice)
> Room 242-J6, IACC Building                        (701) 231-8541 (Fax)
> North Dakota State University, Fargo, ND 58105-5164
> 
> 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