In one word NOM

----- Original Message -----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu <veritas-bu-bounces AT mailman.eng.auburn DOT edu>
To: bolobaboo kabootar <bolobaboo AT gmail DOT com>
Cc: veritas-bu AT mailman.eng.auburn DOT edu <veritas-bu AT mailman.eng.auburn DOT edu>
Sent: Wed Sep 02 15:56:59 2009
Subject: Re: [Veritas-bu] Need urgent help with backup jobs reporting



On Mon, 31 Aug 2009, bolobaboo kabootar wrote:
> We have NBU 6.5.2. Clients are in many policy and schedules. I am
> trying to generate email report for all clients. Does any body have
> script which checks all backup for each client in each schedule/policy
> and reports successful or failed backup with their schedule/policy
> name with start and end time ?
> Example :
> SERVER NAME                POLICY          SCHEDULE_NAME  START_TIME
> END_TIME    STATUS
> =========================================================================================
> TESTSERVER                 TEST1            UNIX           18:00
> 19:00     SUCCESSFULL
>                           TEST2            RMAN           23:00
> 23:30     FAILED
>
> TEST2SERVER                TEST1            UNIX           17:00
> 19:00     SUCCESSFULL
>                           TEST2            RMAN           18:00
> 19:00     SUCCESSFULL
> _______________________________________________
> Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>

Hi,

Have you looked at bpdbjobs?

bpdbjobs
bpdbjobs -most_columns
bpdbjobs -all_columns

Other than that,

bperror -backstat -by_statcode -U

Will give you a nice summary.

Justin.