Re: [Networker] More on 'Query for tapes created on a certain date'

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