Networker

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

2008-04-02 12:52:35
Subject: Re: [Networker] Query for tapes created on a certain date
From: MIchael Leone <Michael.Leone AT PHA.PHILA DOT GOV>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Wed, 2 Apr 2008 12:48:45 -0400
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