Hi.
I am able to directly open it in excel 2010.
Have a nice day.
> On 29 Nov, 2013, at 10:01 pm, Anurag Sharma <sharma.anu...@hotmail.com> wrote:
>
> 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
