Re: [Networker] mminfo question

In regard to: [Networker] mminfo question, Ciolek, Ken said (at 8:57am on...:

>Using Mminfo how can I gather the amount of data that was backed up in the
>last FULL backup

Read up on the man page for mminfo, in particular the section on custom
queries.  If you're talking about the last full backup for a particular
client, client name will be one of the items you specify in the query.
If you're talking about the last full backups for all your clients, then
you won't specify any hosts in your query (or, alternately, you generate
a list of all your hosts and iterate over that list, running mminfo once
for each client).

Either way, you probably need to know when your last full backup(s)
happened.  The reason is that to get just the last full, you probably
want a "more recent than MM/DD/YYYY" in your query:

        mminfo -q 'client=foo.bar.aig.com,level=full,savetime>=12/01/2003' \
                -r 'nfiles,totalsize,client,name'

If you only care about total data from all filesystems/volumes on the
client in question, just have `totalsize' in the report section, and
that's all that will be reported (without even a column header).

Here's a (completely untested) Bourne shell "script" that will first find
all clients that have done a full backup since 07/01/2003, and then
iterate over those clients, and report the total data backed up (per
volume/filesystem) per client since 12/01/2003.  This doesn't completely
solve the problem you asked, because if you've had multiple fulls (or no
fulls) since 12/01/2003 then you'll need to tweak the query, but it
hopefully shows you how to use mminfo:


for c in `mminfo -q 'level=full,savetime>=07/01/2003' -r client | sort -u`
do
        mminfo -q "level=full,savetime>=12/01/2003,client=$c" -r totalsize
done


Tim
--
Tim Mooney                              mooney AT dogbert.cc.ndsu.NoDak 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

--
Note: To sign off this list, send a "signoff networker" command via email
to listserv AT listmail.temple DOT edu or visit the list's Web site at
http://listmail.temple.edu/archives/networker.html where you can
also view and post messages to the list.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=