Here is what I do 
 
vmquery -bx -a|awk '{print $1}'|while read mid
do
  expdate=`/usr/openv/netbackup/bin/admincmd/bpmedialist -U -ev $mid | tail 
+7|head -1|awk '{print $2 "  " $3}'`
echo " $mid     $expdate" >>/tmp/audit.txt
done

cat  /tmp/audit.txt



This will give you the media id with it's expiry date. Media Id's without an 
expiry date means they are already expired.

Hope this helps

Dayal
--

On Fri, 10 May 2002 02:10:04  
 laila aloui wrote:
>
> What i want is : how can i have all media id of tapes
>that are expired.
>
>
>--- "Donaldson, Mark" <Mark.Donaldson AT experianems DOT com>
>wrote:
>> Can you supply a little more detail? Filter expired
>> media from what output
>> or report?
>> 
>> -Mark
>> 
>> -----Original Message-----
>> From: laila aloui [mailto:aloui_laila AT yahoo DOT com]
>> Sent: Thursday, May 09, 2002 11:33 AM
>> To: veritas-bu AT mailman.eng.auburn DOT edu
>> Subject: [Veritas-bu] How to filter media via their
>> expiration date ?
>> 
>> 
>> 
>> HI,
>> 
>> is there a command line to filter media id which are
>> expierd?
>> 
>> thanks in advance
>> 
>> __________________________________________________
>> Do You Yahoo!?
>> Yahoo! Shopping - Mother's Day is May 12th!
>> http://shopping.yahoo.com
>> _______________________________________________
>> Veritas-bu maillist  - 
>> Veritas-bu AT mailman.eng.auburn DOT edu
>>
>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>> 
>
>
>__________________________________________________
>Do You Yahoo!?
>Yahoo! Shopping - Mother's Day is May 12th!
>http://shopping.yahoo.com
>_______________________________________________
>Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
>http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
>