Hi, The source of the raw information is the image database. Here's a script for you. Note, this doesn't take into account multiple copies of one image - it's just a total of the image sizes, ie: sourced data. If you want to have total data written onto the tape, multiply the $19 param by field $21 (number of copies) in order to get total *written* data.
By default, this script searches back 7 days. Supply a different number of days on the command line to change the search depth. If you want the entire history of you box, you'll have to search past your longest retention period (or change bpimage to use a date field rather than the "hoursago" option). output looks like this: ============================================ Report client read totals for past 4 days. ============================================ Server-lt-75-v 46.46 MB Server-lt-48-v 46.85 MB Server-tm-07 67.57 GB Server-lt-94-v 24.39 MB Server-lt-76-v 39.80 MB Server-ad-30 145.11 MB Server-lt-95-v 46.90 MB Server-lp-99-v 165.89 MB ========================================= Total of all Clients 42.71 TB ......................................... #!/bin/ksh PATH=$PATH:/usr/openv/netbackup/bin/admincmd #command line or 7 days daysago=${1:-7} echo "=================================================" echo "Report client read totals for past $daysago days." echo "=================================================\n" hoursago=`expr $daysago \* 24` bpimagelist -hoursago $hoursago | \ awk 'BEGIN {tsum=0} {if($1=="IMAGE"){ clientnames[$2] csum[$2]=csum[$2] + $19}} END { for (c in clientnames) { UNIT="KB" tsum=tsum+csum[c] if (csum[c]>10240) {csum[c]=csum[c]/1024;UNIT="MB"} if (csum[c]>10240) {csum[c]=csum[c]/1024;UNIT="GB"} if (csum[c]>10240) {csum[c]=csum[c]/1024;UNIT="TB"} printf("%20s %10.2f %s\n",c,csum[c],UNIT) } UNIT="KB" if (tsum>10240) {tsum=tsum/1024;UNIT="MB"} if (tsum>10240) {tsum=tsum/1024;UNIT="GB"} if (tsum>10240) {tsum=tsum/1024;UNIT="TB"} print "=========================================" printf("%20s %10.2f %s\n","Total of all Clients",tsum,UNIT) }' exit -----Original Message----- From: veritas-bu-boun...@mailman.eng.auburn.edu [mailto:veritas-bu-boun...@mailman.eng.auburn.edu] On Behalf Of Sushil Sent: Tuesday, April 21, 2009 7:53 AM To: VERITAS-BU@MAILMAN.ENG.AUBURN.EDU Subject: [Veritas-bu] Total Client Data Hi Guys, I am a newbie to netbackup. I have been asked to generate a report which contains how much data is stored by each client on netbackup. And also total data stored on netbackup. I have no idea how to get this. hope you guys will be able to help me out on this... Thanks Sushil +---------------------------------------------------------------------- |This was sent by sushil.gamb...@gmail.com via Backup Central. |Forward SPAM to ab...@backupcentral.com. +---------------------------------------------------------------------- _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu _______________________________________________ Veritas-bu maillist - Veritas-bu@mailman.eng.auburn.edu http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu