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.

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'

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'

Tim
--
Tim Mooney                                        Tim.Mooney AT ndsu DOT edu
Information Technology Services                   (701) 231-1076 (Voice)
Room 242-J6, IACC Building                        (701) 231-8541 (Fax)
North Dakota State University, Fargo, ND 58105-5164

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