On Mon, 31 Aug 2009, bolobaboo kabootar wrote:

> Hi
> 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.
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu