mminfo and management console confusion

Question

I used mminfo to get the tape count of each month.

mminfo -m -q 'savetime>=09/01/2010,savetime<10/01/2010'

mminfo -m -q 'savetime>=10/01/2010,savetime<11/01/2010'

September we used 89 tapes, October we used 60 tapes.

However netwoker management console 's “month client statement” reports 11809GB used in September and 29897GB used in October.

How can more data fits into less amount of tapes ?

coganb · Accepted Answer

Hi,

I don't have enough volumes or data around here to do any robust testing, but from what I can make out the following should work:

1. mminfo -t "one month ago" -r volume

2. Bit more complicated this. From the NMC Reporting, you can have the monthly summary of the amount of
data, for example, in NetWorker Backup Statistics and select Monthly Client Statement. I didn't find anything
that would give you that on a per-volume basis though. You'd have to do a short script to add the size results of
all savesets that went on these volumes for the past month.

Here is an example of a ksh script to do that. This is just an example which works here in my (very small) test
environment and I give it to you to show you what can be done. For use only in a test environment.

find_total_for_vols () {

list_of_vols=`mminfo -t "one month ago" -r volume`
for volume in $list_of_vols; do
size=`mminfo -t "one month ago" -q "volume=$volume" -r totalsize`
total=$(( $(echo $size | sed 's/^.*\s//' | xargs | tr ' ' +) ))
echo $volume $total
done
}

find_total_for_vols

3) In the NMC, go to 'NetWorker Backup Status' and select 'Save Set Details by Client'. This will give
you a report on all clients, when they were backed up and whether it was successful or failed.

4) This depends on what criteria you are using to move out tapes. For example if you want a list of all full volumes

mminfo -av -r volume -q full

otherwise mminfo -m and mminfo -mv give a lot of information about volumes.

-Bobby

DavidHampson-rY · Answer

Your mminfo output will not include tapes that have been relabelled at the time you run mminfo. The count of tapes will not necessarily reflect data only from those months as the tapes may have been written to across several dates outside the range you have specified. The amount of data which writes to one tape is variable and depends upon how compressible the data is. You may also have different tape formats in your environment.

These results are not a straightforward comparison and it would be useful to know what you are trying to prove to advise you further.

nlmnih · Answer

#tapes may have been written to across several dates outside the range you have specified. The amount of data which writes to one tape is variable and depends upon how compressible the data is.#These two points make sense.My site keeps the tapes for a year and uses the same types of tapesI am trying to create an automate way to1. report how many tapes were used ( roughly ) last month,2. how much data were written,3. which clinets fail/success4. which tapes can be moved out library and stored in different location.thanks for your help.

nlmnih · Answer

Thanks Bobby. Your script helped a lot for me.

NetWorker

mminfo and management console confusion

Was this post helpful?