Harpreet,

You are a genius man, thanks a lot, it worked right away.

I know I'm being mean but cant it be modified further to export to exce ?


All please keep a copy of this script it can really help with sizing issues and 
growth rattans

Thank you all for reply

Anurag 

Date: Fri, 29 Nov 2013 20:56:44 +0800
Subject: Re: [Veritas-bu] How to know biggest client backup ?
From: harpreetra...@gmail.com
To: sharma.anu...@hotmail.com
CC: mator...@gmail.com; veritas-bu@mailman.eng.auburn.edu; 
veritas-bu-boun...@mailman.eng.auburn.edu

Hi Anrag, You can try this script. Please change the path accordingly.I have 
tested on Solaris/Linux. it is workiing fine. With Warm Regards
Harpreet

On Fri, Nov 29, 2013 at 7:01 PM, Anurag Sharma <sharma.anu...@hotmail.com> 
wrote:




Awesome Anatoly
Let me try and get back to you.


Anurag

> Date: Fri, 29 Nov 2013 13:03:06 +0400
> Subject: Re: [Veritas-bu] How to know biggest client backup ?
> From: mator...@gmail.com

> To: sharma.anu...@hotmail.com
> CC: veritas-bu@mailman.eng.auburn.edu; 
> veritas-bu-boun...@mailman.eng.auburn.edu

> 
> Anurag,
> 
> 1) install opscenter and use included functionality for reporting
> 
> 2) use NBU command line,
> 
> [root@nbu7 ~]# bpdbjobs -report -gdm
> 25,17,3,1,,,,,1385714991,0000000001,1385714992,,,,,nbu7,,,0

> 24,0,3,0,tmp1,Full,nbu7,nbu7,1385714978,0000000014,1385714992,st1,0,0,0,nbu7,37056,127,100
> 
> where 37056 is backup size. So easily scripting could give like
> clients and their backup size:
> 

> # bpdbjobs -report -gdm | awk -F, '{print $7,$17}' | sort
> 
> 3) export (File->Export) 'Activity monitor' page of Netback
> Administration Console to a file and use external tools (speadsheet)

> to parse it.
> 
> Wed, Nov 27, 2013 at 11:55 PM, Anurag Sharma <sharma.anu...@hotmail.com> 
> wrote:
> > Hi All,
> >

> > My query is simple, I have backups going to VTL then duplicated to tape.
> >
> > Now VTL is filling up badly and need to move some of backups directly to the
> > tapes.
> >

> > Could any one tell me the easiest way to list top 10 backups ( as per their
> > backup size ) on VTL storage unit which I can move directly to the tapes for
> > the time being.
> >

                                          

_______________________________________________

Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu

http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu




-- 
*************************
With Warm Regards.
Harpreet Singh Chana
*************************
                                          
_______________________________________________
Veritas-bu maillist  -  Veritas-bu@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

Reply via email to