[Veritas-bu] Successful Backup Report

[NBU]

Hi Forum,

I need a script that will give me successful backup figure during a period of time for uniq clients.

Can anyone share the script or the procedure to do so pls.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------

[Harpreet SINGH]

Hi,

You can use the below report

/usr/openv/netbackup/bin/goodies/mail_bp_reports

Report example will be like.

NetBackup backup status
=======================

STATUS CLIENT POLICY SCHED SERVER TIME COMPLETED
0 ctloraerp06-b E450-ctl-Wed2 Full ctlorabkp02 05/21/2009
00:49:56
0 ctlorabkp02-b E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
02:01:29
0 ctlorabkp02-b E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
02:01:44
0 ctlorabkp02-b E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
02:01:55
0 ctlorabkp02-b E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
02:02:06
0 ctlorabkp02-b E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
02:12:08
0 ctlorabkp02-b E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
02:12:44
0 ctlsgbiz04-bk E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
02:16:08
0 ctlorabkp02-b SF6800-ctl-Wed Full ctlorabkp02 05/21/2009
02:19:30
0 ctlorabkp02-b E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
02:26:31
0 ctlorabkp02-b E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
03:37:28
0 ctlorabkp02-b E651-ctl-Wed4 Full ctlorabkp02 05/21/2009
03:55:42
0 ctloradb02-bk E450-ctl-Wed3 Full ctlorabkp02 05/21/2009
04:21:37
0 ctlorabkp02-b SF6800-ctl-Wed Full ctlorabkp02 05/21/2009
04:25:57

I am not sure if some one has cutom script with more details.

With Warm Regards
=-=-=-=-=-=-=-=-=-=-=-=-=-
Harpreet Singh Chana

Phone : (O) 6895 - 4326
Fax : (O) 6895 - 4991
=-=-=-=-=-=-=-=-=-=-=-=-=-


Notice
The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
message by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying or distribution of the message, or
any action taken by you in reliance on it, is prohibited and may be
unlawful. If you have received this message in error, please delete it
and contact the sender immediately. Thank you.





NBU
<netbackup-forum@
backupcentral.com To
Sent by: cc
veritas-bu-bounce
***@mailman.eng.aub Subject
urn.edu [Veritas-bu] Successful Backup
Report

05/21/2009 03:48
PM


Please respond to
VERITAS-***@MAILMA
N.ENG.AUBURN.EDU







Hi Forum,

I need a script that will give me successful backup figure during a period
of time for uniq clients.

Can anyone share the script or the procedure to do so pls.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

ForwardSourceID:NT000E145A

[Donaldson, Mark]

Can you give an example of what you're looking for?

-M

-----Original Message-----
From: veritas-bu-***@mailman.eng.auburn.edu
[mailto:veritas-bu-***@mailman.eng.auburn.edu] On Behalf Of NBU
Sent: Thursday, May 21, 2009 1:49 AM
To: VERITAS-***@MAILMAN.ENG.AUBURN.EDU
Subject: [Veritas-bu] Successful Backup Report


Hi Forum,

I need a script that will give me successful backup figure during a
period of time for uniq clients.

Can anyone share the script or the procedure to do so pls.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

[NBU]

I need the number of clients which are successfully backed up between a period of time say 18:00 hrs. to 18:00 hrs.

Currently i am using the following script
---------------------------------------------------------------------------------
grep Policy: /tmp/bp_reports|uniq |grep -v "Storage Lifecycle Policy:"|grep -v
Test|grep -v CATALOG_BACKUP|grep -v Backupsetup |uniq|wc -l
-----------------------------------------------------------------------------

but this gives me the result POLICY wise. Even if i have multiple clients under 1 policy it gives me result as 1 but i need a script which will give me the report client wise.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------

[Brendan Clover]

What about using bperror, e.g.

Sudo bperror -U -backstat -d 5/21/2009 18:00:00 -e 5/22/2009 18:00:00

I then use sort and egrep to list in alphabetical order and to remove the information not wanted.

Regards,

Brendan Clover
Information Technologist
Systems Infrastructure
University of South Australia
Phone: [phone]
Fax: [phone]

Log your own service calls here: http://www.unisa.edu.au/helpdesk
AskIT documentation and FAQs: http://www.unisa.edu.au/askit

-------------------------------------------------------------------------------
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorised. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately

-----Original Message-----
From: veritas-bu-***@mailman.eng.auburn.edu [mailto:veritas-bu-***@mailman.eng.auburn.edu] On Behalf Of NBU
Sent: Friday, 22 May 2009 3:27 PM
To: VERITAS-***@MAILMAN.ENG.AUBURN.EDU
Subject: [Veritas-bu] Successful Backup Report


I need the number of clients which are successfully backed up between a period of time say 18:00 hrs. to 18:00 hrs.

Currently i am using the following script
---------------------------------------------------------------------------------
grep Policy: /tmp/bp_reports|uniq |grep -v "Storage Lifecycle Policy:"|grep -v
Test|grep -v CATALOG_BACKUP|grep -v Backupsetup |uniq|wc -l
-----------------------------------------------------------------------------

but this gives me the result POLICY wise. Even if i have multiple clients under 1 policy it gives me result as 1 but i need a script which will give me the report client wise.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

[NBU]

But this will not take care of duplicate client ids.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------

[NBU]

if streaming is used then i will be getting duplicate clients enteries in the report for single backup.

Hope u get my point.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------

[Dean]

sort -u

Post by NBU
if streaming is used then i will be getting duplicate clients enteries in
the report for single backup.
Hope u get my point.
+----------------------------------------------------------------------
+----------------------------------------------------------------------
_______________________________________________
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

[j***@administaff.com]

Here is my daily backup summary report script

I test for date, because on Monday morning I want to go back to 5 pm
last Friday and see the backups for all weekend.
The rest of the week I just go from 5 pm the night before.
This is run at 9 am each morning via cron.
Adjust your time to include the hours you want reported.

This breaks them down according to Status Code.
So all that finished ok are in the Zero section, each client name only
showing once even if they have multi jobs.

I always do a scroll to the bottom to see the ones with errors.


rptdate=`cat /opt/openv/scripts/temp/date4dlyrpt`
mydate=`date +%w`
if [ $mydate == 1 ]
then
h=64
else
h=16
fi
/usr/openv/netbackup/bin/admincmd/bperror -U -backstat -hoursago $h
-by_statcode> /opt/openv/scripts/temp/bksum.txt
mail -s "YourLocation Daily Backup Summary for $rptdate"
***@yourcompany.com < /opt/openv/scripts/temp/bksum.txt
date '+%a %b %d %Y' > /opt/openv/scripts/temp/date4dlyrpt

-----Original Message-----
From: veritas-bu-***@mailman.eng.auburn.edu
[mailto:veritas-bu-***@mailman.eng.auburn.edu] On Behalf Of NBU
Sent: Saturday, May 23, 2009 1:18 AM
To: VERITAS-***@MAILMAN.ENG.AUBURN.EDU
Subject: [Veritas-bu] Successful Backup Report


if streaming is used then i will be getting duplicate clients enteries
in the report for single backup.

Hope u get my point.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

[Donaldson, Mark]

Here's what I use. I gives output that looks like below, totals by
client, then broken down by policy.

Run it without options for a 24-hour report or specify a number of hours
on the command line to see greater depth. Change the
"***@YOURDOMAIN.COM" at the top of the script for your mail address. I
run it daily via cron.

=====================================
## Report Start: Mon May 25 08:00:01 MDT 2009 for past 168 hours.

## General Statistics
Total Backup Jobs: 7249
Total Volume: 28.63 TB

## Backup totals by client

righthand = 1.2 GB
: Unix_FS_DevTest_1 1.2 GB (2 jobs)
: Unix_FS_logs 18.4 MB (2 jobs)

dns1 = 298.4 MB
: Unix_FS_Firewalled 216.4 MB (3 jobs)
: Unix_FS_logs 82.0 MB (2 jobs)

dns2 = 384.3 MB
: Unix_FS_Firewalled 265.8 MB (3 jobs)
: Unix_FS_logs 118.5 MB (2 jobs)

server-tm-07 = 78.9 GB
: NT_CO_Whs 78.9 GB (1 jobs)
<snip>
## Backup totals by policy
<snip>
Unix_FS_DevTest_1: 4.7 GB
Unix_FS_DevTest_2: 10.6 GB
Unix_FS_DevTest_3: 21.3 GB
Unix_FS_Firewalled: 98.6 GB
Unix_FS_Firewalled_Tier1: 13.2 GB
Unix_FS_Firewalled_Web: 1.9 GB
Unix_FS_Prod_1: 163.9 GB
Unix_FS_Prod_2: 145.6 GB
<snip>




-----Original Message-----
From: veritas-bu-***@mailman.eng.auburn.edu
[mailto:veritas-bu-***@mailman.eng.auburn.edu] On Behalf Of NBU
Sent: Thursday, May 21, 2009 1:49 AM
To: VERITAS-***@MAILMAN.ENG.AUBURN.EDU
Subject: [Veritas-bu] Successful Backup Report


Hi Forum,

I need a script that will give me successful backup figure during a
period of time for uniq clients.

Can anyone share the script or the procedure to do so pls.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

[NBU]

MDONALDSON : you have not given the script

JUDY : Would like to ask how do you take care of BCV Based backups in this report format.

Suppose if i have 1 media server on which BCV of 10 different servers are mounted and then backup is taken. How do you report that.

WRT BC Tape backup, In your report the media server comes only once as a client so how will you get the rest 9 server report.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------

[Donaldson, Mark]

Apologies for the slow response - I was on vacation.

My earlier message to this board has the script as an attachment
"rpt_client_totals".

It's a shell script, I don't use "extensions" as a rule on scripts.

-M

-----Original Message-----
From: veritas-bu-***@mailman.eng.auburn.edu
[mailto:veritas-bu-***@mailman.eng.auburn.edu] On Behalf Of NBU
Sent: Friday, May 29, 2009 6:01 AM
To: VERITAS-***@MAILMAN.ENG.AUBURN.EDU
Subject: [Veritas-bu] Successful Backup Report


MDONALDSON : you have not given the script

JUDY : Would like to ask how do you take care of BCV Based backups in
this report format.

Suppose if i have 1 media server on which BCV of 10 different servers
are mounted and then backup is taken. How do you report that.

WRT BC Tape backup, In your report the media server comes only once as a
client so how will you get the rest 9 server report.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

[j***@administaff.com]

The report I use - shows for each Error return code which servers had
it.
So if a server has 6 jobs and they all died with a 1 the server name
would show up once under code 1.

If 5 of the jobs were 0 and 1 job was 1 then the server name would show
up under both 0 and 1.

The point of my report was to see the 'odd' return codes like 71, 150,
49

Those I need to look and find out what went wrong. I just care to see
what servers are having issues - it does not matter to me how many of
the jobs failed but that they did fail.


If you want more detail then play with the command.

At one point I had it reporting EVERY job, and details about all that
failed.

Like this:
01/02/2009 18:15:21 <mediaserver> <clientname> from client
<clientname>: WRN - can't
open file: C:\Program
Files\TelStrat\CallParrot\CallParrotConfig_Data.mdf
(WIN32
32: The process cannot access the file because it is
being
used by another process. )



But this was more then I needed as I always go to the console to look
into the errors anyway.
I tested out 7 or 8 different ways with the command before I got the
format I liked. You can just test yourself until you get what you like.



-----Original Message-----
From: veritas-bu-***@mailman.eng.auburn.edu
[mailto:veritas-bu-***@mailman.eng.auburn.edu] On Behalf Of NBU
Sent: Friday, May 29, 2009 7:01 AM
To: VERITAS-***@MAILMAN.ENG.AUBURN.EDU
Subject: [Veritas-bu] Successful Backup Report


MDONALDSON : you have not given the script

JUDY : Would like to ask how do you take care of BCV Based backups in
this report format.

Suppose if i have 1 media server on which BCV of 10 different servers
are mounted and then backup is taken. How do you report that.

WRT BC Tape backup, In your report the media server comes only once as a
client so how will you get the rest 9 server report.

+----------------------------------------------------------------------
|This was sent by ***@rediffmail.com via Backup Central.
|Forward SPAM to ***@backupcentral.com.
+----------------------------------------------------------------------


_______________________________________________
Veritas-bu maillist - Veritas-***@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu