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