Networker

[Networker] mminfo; excluding certain values of "name" queryspec

2011-07-20 11:55:05
Subject: [Networker] mminfo; excluding certain values of "name" queryspec
From: Michael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 20 Jul 2011 11:56:10 -0400
I'm confused. I am trying to run an mminfo report on savesets saved from a 
certain client, and I want to exclude a certain saveset.
(I want all savesets of client NT_SAN1, except for the saveset 
"H:\Users"). I thought the "!" in front of the queryspec would do that. 
But it seems to be doing the reverse:

>mminfo -avot -r "client,name,savetime(22),totalsize(4)" -q 
"client=nt_san1,savetime>07/16/2011,savetime<07/18/2011,!name='H:\Users'"

 name                                           date     time total
nt_san1   H:\Users                         7/16/2011 9:36:10 AM 1351 GB
nt_san1   H:\Users                         7/16/2011 9:36:10 AM 1351 GB
nt_san1   H:\Users                         7/16/2011 9:36:10 AM 1351 GB

This is the opposite of what I want; I really want, which is  "name != 
'H:\Users". 

How can I construct an mminfo query that shows me that?

Thanks
-- 
Michael Leone
Network Administrator, ISM
Philadelphia Housing Authority
2500 Jackson St
Philadelphia, PA 19145
Tel:  215-684-4180
Cell: 215-252-0143
<mailto:michael.leone AT pha.phila DOT gov>

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