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

Hi.

You can try:

mminfo -s server_networker -q "savetime>=3/27/2008" -c client_networker -r 
"client,
volume, name, savetime(22)"

Best Reguards.
Daniel.


On Wed, 2 Apr 2008 12:54:01 -0400, Teresa Biehler wrote
> I believe using a date with savetime implies a time as well as a date.
> 
> -T
> 
> -----Original Message-----
> From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] 
> On
> Behalf Of MIchael Leone
> Sent: Wednesday, April 02, 2008 12:49 PM
> To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
> Subject: Re: [Networker] Query for tapes created on a certain date
> 
> EMC NetWorker discussion <NETWORKER AT LISTSERV.TEMPLE DOT EDU> wrote on 
> 04/02/2008 12:18:40 PM:
> 
> > In regard to: [Networker] Query for tapes created on a certain
> date,...:
> > 
> > > I want to run a query that would show me what tapes were used by a
> > > particular client on a specific date.
> > >
> > > Example:
> > >
> > > client = admman002
> > > date = 2008-03-31
> > 
> > Does
> > 
> >     mminfo -q
> 'client=admman002,savetime>03/30/2008,savetime<04/01/2008' 
> \
> >        -r volume
> > 
> > work?
> 
> And it does! Thanks. But why doesn't this work?
> 
> mminfo -avot -q "client=admnman002,savetime=03/31/2008" -r 
> "client,volume,name,savetime(22)"
> 6095:mminfo: no matches found for the query
> 
> There are definitely savesets on that date, for that client. When I use 
> your queryspec, I get:
> 
>  client     volume          name                               date time
> 
> ssid       ssflags clflg
> admnman002  897337         SYSTEM DB:\                      3/31/2008 
> 6:30:47 PM 3119605272 vF
> admnman002  897337         SYSTEM FILES:\                   3/31/2008 
> 6:31:37 PM 3018942026 vF
> admnman002  897337         SYSTEM STATE:\                   3/31/2008 
> 6:32:55 PM 2800838296 vF
> admnman002  896583         ASR:\                            3/31/2008 
> 6:35:13 PM 2716952354 vF
> admnman002  897337         C:\                              3/31/2008 
> 6:35:14 PM 2700175139 vF
> 
> Why can I not query an exact date as savetime? It makes putting this in
> a 
> script a bit more challenging, since I'd have to specify the date I
> really 
> want to see, and then construct the query to be 1 day before and 1 day 
> after. I'd rather not have to do date arithmetic in my script (Windows 
> shell scripts aren't exactly brainy ...).
> 
> 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


Daniel Raul Costa 

-- 
CAS Tecnologia S/A
Av. Paulista, 1776 - 8o. andar 
01310-921 
São Paulo - SP - Brasil 
Fone: +55 11 3287.2227

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