Tape usage reporting
Netbackup 7104, Windows 2008r2, OpsCenter Analytics 7104
I am trying to compile some reporting on tape usage, so we can better plan moving forward. I'm wanting to look back month-to-month for perhaps the last 6 months to a years to generate some trending, and also to help bolster my argument to lessen our depenedency on tape storage for short-term data. I'm wanting the output to show me how many tapes are used on average for daily data backups with shorter retention, and which ones go offsite for 7 years (our monthly fulls). So far, I've tried the Tapes Written option under Tape Reports in the Netbackup GUI, I've tried the client summary dashboard under Client Reports in OpsCenter (I selected the date range, ran the report, exported to a CSV, and summed the "volume" column), and I have even manually extracted data from the catalog and just counted tapes. I'm getting wildly ranging amounts of data, as well as tape numbers, and I need this to be accurate. I've been beating on this on and off for about 3 days, and when I think I'm getting somewhere, I get stopped by some errant reporting values that make no sense based on the actually quantities of tapes we have been purchasing. For example, in 2012, we were purchasing an average of about 400 tapes per quarter, based on the estimated number of tapes leaving for 7 years, since those 7-year backups slowly diminish the tape supply. But, when I run the number by just counting tapes from the catalog with 7 year retention, I should be seeing approx 400 tapes per quarter headed off site for 7-years, but I am not. On the other hand, other than inventory I havent used yet, and available scratch at Iron Mountain, I don’t have a huge number of tapes just sitting in scratch pool waiting to be used either, so the tapes we have ordered in the past are getting used.
In your experience, what methods have you used to get your most accurate results on tape reporting?