I've got an excel pivot table I use for a peek at this type of information, 
I'll send it your way.  Basically it looks at amount of data backed up in jobs 
marked as fulls on a week by week basis.  If your report looks something like
 
Server 1 - 50GB, 50GB, 0GB
Server 2 - 75GB, 75GB, 75GB
Server 3 - 60GB, 60GB, 60GB
 
You know Server 1 has an issue.  I use it more to track weekly data totals, 
looking for file servers and application servers whose data is growing by 
greater than 1-2% per week, but it can also do what you are asking for here.  
Because its excel its not ideal, and it requires a cut and paste of data from 
the client report, but its better than nothing.
 
If I were to script this I would write something in perl to go server by policy 
and look for instances of no full backup in the last 7 or 8 days assuming you 
run weeklies.  You could get more advanced and compare this week's weekly 
versus last weeks weekly in regards to KBs written to tape etc.. but thats a 
sticky wicket.
 
-Jonathan
 

________________________________

From: veritas-bu-bounces AT mailman.eng.auburn DOT edu on behalf of Brandon 
Zermeno
Sent: Thu 7/19/2007 7:59 PM
To: Veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] retentions



This is what I am looking for. We have had nothing but useless junk from
Command Central and Advanced Reporter and I have no faith in the latest
version Backup Reporting. Does Aptare manage to show you when the last
backup was run successfully?
In this case we overwrote the tape so importing was not an option.

-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of Darren
Dunham
Sent: Thursday, July 19, 2007 4:38 PM
To: Veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] retentions

> As far as I know once images expire they are deleted from the
Netbackup
> catalog - as a result (and as you state) it is not possible to
unexpire
> images within the catalog via bpexpdate.  The only option is to
manually
> import the images off the tapes, assuming you know what tapes have the
> images you need and they haven't yet been overwritten.  If you are
able
> to do the import then you can assign whatever retention you want.

Yes.  I think he's looking for something like the default behavior of
EMC Networker, where the image's expiration is suspended if there
haven't been any later successful backups.  So not recover (via import)
after the fact, but prevent the last backup from being expired at all.

I can think of how using some scheduled scripts could get pretty close.
Examine the catalog for the last full backup of all the
machine/filesystem.  If it's approaching expiration, push the expiration
date back.

As long as the script runs (successfully) at least once within the
"pushback" period, it'll prevent the expiration. 

Finding the image corresponding to a particular filesystem isn't
necessarily trivial though.  And you really need to track by filesystem.
If the machine has done recent successful full backups, but one
filesystem failed each time, you'd like to delay that filesystem's
expiration.

--
Darren Dunham                                           ddunham AT taos DOT com
Senior Technical Consultant         TAOS            http://www.taos.com/
Got some Dr Pepper?                           San Francisco, CA bay area
         < This line left intentionally blank to confuse you. >
_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

CONFIDENTIALITY NOTICE:  This email may contain confidential and privileged 
material for the sole use of the intended recipient(s).  Any review, use, 
distribution or disclosure by others is strictly prohibited.  If you have 
received this communication in error, please notify the sender immediately by 
email and delete the message and any file attachments from your computer.  
Thank you.

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu



_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu