Totalsize is stored internally in bytes. Try totalsize>100000000
instead of totalsize>100MB



> -----Original Message-----
> From: EMC NetWorker discussion 
> [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On Behalf Of Cox, Shawn
> Sent: Friday, 15 February 2008 7:48 AM
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Subject: Re: [Networker] Help with Query.
> 
> In regard to: [Networker] Help with Query., Cox, Shawn said 
> (at 1:54pm on...:
> 
> > First thing I'd like to do is an mminfo query which returns 
> ssid's on a specific volume which are greater than a specific size.
> >
> > mminfo -av -r totalsize,ssid -q "volume=<volumename>, 
> totalsize > 100MB"
> > returns totalsize and ssid of every ssid on the volume, yet if I
> > reverse the > to a < it works and returns ssids less than 100MB
> 
> What version of NetWorker?  Your query works for me on 7.2.2. 
>  Even if I chop it down to the way I would write it:
>         mminfo -q 'volume=NDSU_ITS_Misc:042,totalsize>100MB' 
> -r ssid,totalsize
> it still works as expected.
> 
> 
> Response:
> I'm at v7.2.2b422 on Windows.
> 
> mminfo -q "volume=LANDISK.001,totalsize>100MB" -r ssid,totalsize
> 
> even formatting it as you have I get back *all* ssids that 
> are on the given volume.  If I change only the > to a < I get 
> a smaller subset of ssid's but they are all under 8KB in 
> size(contrary to my original post).  This is very strange.
> 
> 
> 
> > Second thing I'd like to do is return a list of ssids on a volume in
> > size order beginning with the largest first.  but -o does 
> not have an
> > atribute for ordering by saveset size.  (l)ength does not 
> return them
> > in saveset size order.
> 
> You'll need to use external tools to accomplish this.  Something like
> 
> mminfo -xc, -q 'volume=NDSU_ITS_Misc:042' -r 'totalsize,ssid' \
>         | sort -n -r -k 1 -t , | cut -d , -f 2 | egrep -v 'ssid'
> 
> Response:
> OK. Thought I might have to employ outside tools.
> 
> 
> > Third thing I'd like to do is return a list of ssids for a secific
> > saveset name on a specific volume.
> >
> > mminfo -av -q "volume=<volumename>, name=<saveset name>" returns no
> > matches even though there are most definitely savesets by 
> that name on
> > the volume.
> 
> Also works for me under 7.2.2:
> 
> mminfo -av -q "volume=NDSU_ITS_Misc:042,name=/var" -r 
> 'ssid,client,name'
> 
> Response:
> Digging a little further I got this one to work I had a space 
> where I shouldn't have and removed the "'s.
> mminfo -av -q volume=LANDISK.001,name=X:\ -r ssid returns the 
> ssid's I wanted.
> 
> Thanks very much for your input Tim.
> 
> --Shawn
> 
> To sign off this list, send email to 
> listserv AT listserv.temple DOT edu and type "signoff networker" in 
> the body of the email. Please write to 
> networker-request AT listserv.temple DOT edu if you have any 
> problems with this list. You can access the archives at 
> http://listserv.temple.edu/archives/networker.html or
> via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
> 

NOTICE
This e-mail and any attachments are confidential and may contain copyright 
material of Macquarie Group Limited or third parties. If you are not the 
intended recipient of this email you should not read, print, re-transmit, store 
or act in reliance on this e-mail or any attachments, and should destroy all 
copies of them. Macquarie Group Limited does not guarantee the integrity of any 
emails or any attached files. The views or opinions expressed are the author's 
own and may not reflect the views or opinions of Macquarie Group Limited.

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER