Re: [Veritas-bu] Backup Growth Stats
On Wed, Dec 28, 2005 at 03:13:37PM -, Paul Porcelli wrote: > are there any Netbackup stats which will show me the amount of data > backed up. > > I'm hoping to go as far back as possible and thus build up a picture > of growth in the amount of data backed up over the last year. For long-term stats, you're going to need a backup reporting package. For simple reporting like this, NetBackup Operations Manager (free with NBU 6) should suffice. Unfortunately, you don't have a year's worth of data going back, so you're going to be out of luck until a year after you install a reporting package. If every backup you've done in the past year has not yet expired, there's hope for you right now, but if not, there's nothing in NetBackup to report on expired tapes and images. .../Ed -- Ed Wilts, Mounds View, MN, USA mailto:[EMAIL PROTECTED] ___ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
Re: [Veritas-bu] Backup Growth Stats
Paul Porcelli wrote, in part, on 12/28/2005 10:13 AM:
are there any Netbackup stats which will show me the amount of data backed up.
I'm hoping to go as far back as possible and thus build up a picture of
growth in the amount of data backed up over the last year.
You could use the logs or jobs DB to calculate amount of data backed
up. I take a different tact and sum the size of images written on each
of the past n days. Note that images expire according to your retention
policies, so how far back you can go depends on your shortest retentions
(after that, this method understates the amount of data backed up, for
it is really displaying the amount of data now in storage).
For example, I have a script named "GBperDay.rex" that runs daily. It
uses bpimagelist, grep and awk (Unix). Here is a sample report:
GigaBytes and KiloFiles of data backed up each day for preceding 4
weeks
(all clients)
Date GBytes Kfiles Date GBytes Kfiles Date GBytes Kfiles Date
GBytes Kfiles
11/30/05509 5661 12/07/05495 5617 12/14/05529 6475 12/21/05
511 6002
12/01/05515 6498 12/08/05491 6807 12/15/05577 7060 12/22/05
554 6751
12/02/05 1246 10741 12/09/05 1033 9319 12/16/05 1159 10433 12/23/05
1103 10677
12/03/05 2324 33430 12/10/05 2215 34080 12/17/05 2044 33295 12/24/05
2118 33471
12/04/05489 4828 12/11/05371 3475 12/18/05314 3382 12/25/05
291 3323
12/05/05377 4883 12/12/05474 6194 12/19/05428 5091 12/26/05
402 4841
12/06/05442 5613 12/13/05510 6132 12/20/05464 5411 12/27/05
243 4714
(Please note that the current day is often understated, for backups in progress
or not yet started are not reported).
Here is "GBperDay.rex", a Rexx script, ... probably fairly easy to translate to
your platform and language of choice:
#!/usr/local/bin/rexx
/* GBperDay.rex -- display the number of gigsbytes backed up for all clients
for each day during the past 28 (4 weeks)
2003-09-09 [EMAIL PROTECTED]
Note: Using col 19 of IMAGE records instead of col 4 of FRAG records
means we're measuring data backed up, not data stored which would
include extra copies for offsite backup.
*/
daytoday = date('B')
say " GigaBytes and KiloFiles of data backed up each day for preceding 4
weeks"
say " (all clients)"
say " "
say " Date GBytes Kfiles Date GBytes Kfiles Date GBytes Kfiles Date
GBytes Kfiles"
do i=daytoday-27 by 1 for 7 /* each of 7 days of a week */
line = ''
do j=i by 7 for 4
call bpimagelist /* do j'th day w/result in "n." */
line = line date("U",j,"B") ,
format(word(d.1,1)/1024/1024,6,0),
format(word(d.1,2)/1024,6,0)
end
say line
end
j = daytoday-1 /* stash yesterday's values in a permanent record */
call bpimagelist
line = date("U",j,"B") format(word(d.1,1)/1024/1024,6,0),
format(word(d.1,2)/1024,6,0)
'echo' line '>> GBperDay.history'
exit 0
bpimagelist: /* sum images and files for day "j"" */
/* returns result pair in stem d.*/
address SYSTEM ,
"/usr/openv/netbackup/bin/admincmd/bpimagelist -l",
"-d" date("U",j,"B") "-e" date("U",j,"B"),
"| grep IMAGE",
"| awk ' {totKB+=$19; totFiles+=$20 }",
"END { print totKB, totFiles }'",
with output stem d.
return
(end of "GBperDay.rex")
cheers, wayne
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
RE: [Veritas-bu] Backup Growth Stats
You can view the amount of data per backup using bpimagelist. The depth of
data is the same as the depth of your retention policies.
Field 19 of the "IMAGE" record is the backup size in KB.
-M
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Paul
Porcelli
Sent: Wednesday, December 28, 2005 8:14 AM
To: veritas-bu@mailman.eng.auburn.edu
Subject: [Veritas-bu] Backup Growth Stats
Hi folks,
are there any Netbackup stats which will show me the amount of data
backed up.
I'm hoping to go as far back as possible and thus build up a picture of
growth
in the amount of data backed up over the last year.
Many thanks.
Paul
Privileged/Confidential information may be contained in this Email and any
files transmitted
with it. If you are not the intended recipient you should not retain, copy
or use this Email
for any purpose or disclose all or part of its contents to any person. If
you have received
this Email in error please notify the postmaster and sender immediately and
delete this
Email from your system.
Opinions, conclusions and other information in this message that do not
relate to the
official business of Scottish Water ("SW") and / or Scottish Water Solutions
Ltd ("SWS")
shall be understood as neither given nor endorsed by them. The contents of
Emails sent and
received by SW and SWS are monitored.
WARNING: Although SW and SWS have taken reasonable precautions to ensure no
viruses or other
malicious software are present, SW and SWS cannot accept responsibility for
any loss or
damage arising from the use of this Email or attachments however caused. The
recipient
should therefore check this Email and any attachments for the presence of
viruses or other
malicious software.
Scottish Water
www.scottishwater.co.uk
www.scottishwatersolutions.co.uk
[EMAIL PROTECTED]
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
[Veritas-bu] Backup Growth Stats
Hi folks,
are there any Netbackup stats which will show me the amount of data
backed up.
I'm hoping to go as far back as possible and thus build up a picture of
growth
in the amount of data backed up over the last year.
Many thanks.
Paul
Privileged/Confidential information may be contained in this Email and any
files transmitted
with it. If you are not the intended recipient you should not retain, copy or
use this Email
for any purpose or disclose all or part of its contents to any person. If you
have received
this Email in error please notify the postmaster and sender immediately and
delete this
Email from your system.
Opinions, conclusions and other information in this message that do not relate
to the
official business of Scottish Water ("SW") and / or Scottish Water Solutions
Ltd ("SWS")
shall be understood as neither given nor endorsed by them. The contents of
Emails sent and
received by SW and SWS are monitored.
WARNING: Although SW and SWS have taken reasonable precautions to ensure no
viruses or other
malicious software are present, SW and SWS cannot accept responsibility for any
loss or
damage arising from the use of this Email or attachments however caused. The
recipient
should therefore check this Email and any attachments for the presence of
viruses or other
malicious software.
Scottish Water
www.scottishwater.co.uk
www.scottishwatersolutions.co.uk
[EMAIL PROTECTED]
___
Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
