thanks for that. Tried again with your line, got a failure, then added -s
and it did work. so it was my mistake, in my confusion I was trying lots of
different options, so I've been putting -s on some but not on other lines.
I see now what's going on here, and it's still very odd to me.
The rule is : the database always expects queries in its in USA format
MM/DD/YYYY
*BUT*, the output will be in local format, i.e. DD/MM/YYYY for me.
So, NetWorker refuses to talk to you, unless you agree to talk to it in it's
native English (which in this case, ONLY the American date-time
sub-variation of that language will do). It then does a *computation* to
alter the database format to output to local format ...
if i talk to a system in USA MM/DD/YYYY format, I would kinda like it to
reply to me in USA MM/DD/YYYY format.
if i talk to a system in rest-of-the-world DD/MM/YYYY format, I would kinda
like it to reply to me in rest-of-the-world DD/MM/YYYY format.
that seems common-sense, but it's not "NetWorker-sense" (which is
strongly related to "Murphy's law" I think)
bottom line : it's inconsistent and quite odd.
thanks for helping to clear up yet another NetWorker confusion.
I think I should take up Astrology reading to better understand NetWorker.
On Sat, Apr 5, 2008 at 3:17 PM, Michael Nored <mrnored AT netzero DOT net>
wrote:
> Roy,
>
> Seems to work of me, I did a cut and paste.
>
> C:\>mminfo -q "savetime>03/10/2008,savetime<04/05/2008" -r
> "volume,client,savetime(16),written"
> volume client date time written
> AFTD.001 mrnored 3/23/2008 52 MB
> AFTD.001 mrnored 3/23/2008 52 MB
> AFTD.001 mrnored 4/2/2008 52 MB
> AFTD.001 mrnored 4/2/2008 52 MB
> AFTD.001 mrnored 4/3/2008 52 MB
> AFTD.001 mrnored 4/3/2008 52 MB
> AFTD.001 mrnored 3/23/2008 52 MB
>
>
> Michael Nored
> Consultant
> Nored Consulting, LLC
>
> M: (407) 399-8162
> T: (352) 350-7142
> E: mnored AT Netzero DOT net
>
> -----Original Message-----
> From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU]
> On
> Behalf Of Roy Subs
> Sent: Saturday, April 05, 2008 8:39 AM
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Subject: [Networker] More on 'Query for tapes created on a certain date'
>
> I was going through some postings on using date limits with mminfo, in
> particular "Query for tapes created on a certain date" recently
>
> Firstly I wanted to do an output from 2nd April back to 10th March. I
> tried
> British time format DD/MM/YYYY:
>
>
>
> mminfo -s server1 -q "savetime>10/03/2008,savetime<04/02/2008" -c tank -
> r "volume,client,savetime(16),written"
>
> invalid value specified for `savetime'
> usage: mminfo [-avV] [-o order] [-s server] [-x exportspec] [report]
> [query] [volname...]
>
> <report>: [ -m | -p | -B | -S | -X | -r reportspec ]
> <query>: [-c client] [-N name] [-t time] [-q queryspec]
>
>
>
> ok, syntax error, and saying that the savetime format is invalid.
> I will now try the USA format MM/DD/YYYY:
>
>
>
> mminfo -s server1 -q "savetime>03/10/2008,savetime<04/02/2008" -
> r "volume,client,savetime(16),written"
>
> 6095:mminfo: no matches found for the query
>
>
>
> This is an error, but not a syntax error, it seems happy with the input
> buts says there is nothing there. However, there IS something there.
>
> I tried many many variations, and in desperation, I tried 4th of April to
> the 1st of January (so that the MM=DD in both cases). Bizarrely, this
> works:
>
>
>
> mminfo -s server1 -q "savetime>01/01/2008,savetime<04/04/2008" -
> r "volume,client,savetime(16),written"
> volume client date time written
> ark.a server1 15/03/2008 17:19 31 GB
> ark.b server1 15/03/2008 17:19 28 GB
> ark.b server1 18/03/2008 20:18 28 GB
> egt.001 server1 02/04/2008 04:47 3263 MB
> egt.001 server1 02/04/2008 18:56 3263 MB
> egt.001 server1 02/04/2008 18:53 3263 MB
> egt.001 server1 02/04/2008 04:45 3263 MB
>
>
>
> As you can see, dates within my original query ARE there. Also, note that
> the output date format is in DD/MM/YYYY. This is completely inconsistent.
> Could someone with better experience of how mminfo handles savetime dates
> please explain to me how to make a consistent query from date1 to date2
> with mminfo.
>
> 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
>
>
>
>
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
|
