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: harpreetrajan AT gmail DOT com
To: sharma.anurag AT hotmail DOT com
CC: matorola AT gmail DOT com; veritas-bu AT mailman.eng.auburn DOT edu; veritas-bu-bounces AT mailman.eng.auburn DOT 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.anurag AT hotmail DOT 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: matorola AT gmail DOT com
> To: sharma.anurag AT hotmail DOT com
> CC: veritas-bu AT mailman.eng.auburn DOT edu; veritas-bu-bounces AT mailman.eng.auburn DOT 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.anurag AT hotmail DOT 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 AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu

--
*************************
With Warm Regards.
Harpreet Singh Chana
*************************