A command I find helpful, but isn't exactly what you are looking for, is
to find all the volumes that are currently expired (all savesets expired
and in a recycle state):

mminfo -q "volrecycle" -r 'pool,volume' | grep -v SCRATCH
note: I use media management and a common scratch pool.

-----Original Message-----
From: EMC NetWorker discussion [mailto:NETWORKER AT LISTSERV.TEMPLE DOT EDU] On
Behalf Of Francis Swasey
Sent: Saturday, September 27, 2008 4:27 PM
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Subject: Re: [Networker] mminfo command query?

Using "volretent=10/21/08" is specifying exactly midnight the morning of

10/21/08.  To get what you want, you have to use a date range...

mminfo -q 'pool=pool1, location=Offsite, volretent>10/21/08, 
volretent<10/22/08' ....

This will give you everything that is set to expire at some time on 
10/21/08 (that is not exactly 00:00:00 -- but you already know that you 
don't have any tapes with that exact expiration date/time).

Frank

On 9/27/08 8:45 AM, anandhg wrote:
> Using mminfo command I want to find out all the media which are going
to expire on given date.
> I tried it using 
> mminfo -q pool=pool1 -q location=Offsite  -q 'volretent=10/21/08' -r
'volume,volretent' -ot
> I didn't get any output.
>
> So I have to give 
> mminfo -q pool=pool1 -q location=Offsite  -q 'volretent<10/22/08' -r
'volume,volretent' -ot
>
> I think mminfo searches for exact date and time. Is there any other
way to get the media which will expire on particular date instead of
giving the date and time.
>
>
+----------------------------------------------------------------------
> |This was sent by anandhg AT gmail DOT com via Backup Central.
> |Forward SPAM to abuse AT backupcentral DOT com.
>
+----------------------------------------------------------------------
>
> 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
>   

-- 
Frank Swasey                    | http://www.uvm.edu/~fcs
Sr Systems Administrator        | Always remember: You are UNIQUE,
University of Vermont           |    just like everyone else.
  "I am not young enough to know everything." - Oscar Wilde (1854-1900)


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