Here's really what I want.  We fall under the Sarbanes-Oxley crap.  Every 6 
month we have to take an audit of our backups and have the customer sign off 
that everything is OK.  What I do now is run a script that does a 
"bpcllist -L -byclient $Cl |egrep 'Policy Name|Active|Include'.  The 
information can then be viewed via a web page. The problem I have is it's hard 
to get the days of the week the backup runs and this is what the customer is 
looking for.  Just because it says the policy is "active" doesn't necessarily 
mean its runs a daily schedule.  Hopefully this is the detail you were looking 
for.

Randy Zimmer
Unix System Administrator
Monsanto Enterprise Infrastructure Team
Office:  314-694-3109
Pager:  314-294-7966
rkzimm AT monsanto DOT com

-----Original Message-----
From: Mark.Donaldson AT cexp DOT com [mailto:Mark.Donaldson AT cexp DOT com] 
Sent: Tuesday, March 29, 2005 4:22 PM
To: randy.k.zimmer AT monsanto DOT com; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Backup Audit script...

So you want a script that says on what day a backup runs?

It's no so easy to generate.  It's really a function of when the window is
open AND the frequency of the backup.  My archived-redo backups are 7x24
windows (with a few 1x168's I think) and a two-hour frequency.  It runs 12
times a day based on this window.  Still others have two open windows per
week but the frequency keeps it to running only once per week (unless
there's a backup failure the first attempt).  I call these "second chance"
schedules.

You might just print the policy for them: 

  bppllist <policy_name> -U

... or, perhaps, all policies for a given client:

  bppllist -byclient <clientname> -U

and the schedule windows & frequency are there:

  Schedule:          Incr
    Type:            Differential Incremental Backup
    Frequency:       every 1 day
    Maximum MPX:     4
    Synthetic:       0
    PFI Recovery:    0
    Retention Level: 4 (2 months)
    Number Copies:   1
    Fail on Error:   0
    Residence:       (specific storage unit not required)
    Volume Pool:     (same as policy volume pool)
    Daily Windows:
          Sunday     04:00:00  -->  Sunday     16:00:00
          Monday     04:00:00  -->  Monday     16:00:00
          Tuesday    04:00:00  -->  Tuesday    16:00:00
          Wednesday  04:00:00  -->  Wednesday  16:00:00
          Thursday   04:00:00  -->  Thursday   16:00:00
          Saturday   04:00:00  -->  Saturday   16:00:00

...It's a start.  Other than that, if you've got different ideas, lots of
things are possible but you'll have to detail your question a little more.

-M



-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of ZIMMER, 
RANDY K
[AG/1000]
Sent: Tuesday, March 29, 2005 10:26 AM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: [Veritas-bu] Backup Audit script...


Has anyone written a script to do a backup audit?  We have something in
place to get information about our backups but the hardest thing to get is
the days of the week the backup runs. The user comes back and says I see my
backup is active but when does it run?  Can anybody help on this?
Randy Zimmer
Unix System Administrator
Monsanto Enterprise Infrastructure Team
Office:  314-694-3109
Pager:  314-294-7966
rkzimm AT monsanto DOT com