Feroz,

You might want to take a look at APTARE StorageConsole. 
At the highest level, it provides backup administrators, managers and
end users with following:
-- Historical Reporting
-- Real-Time Dashboards
-- Future Forecasting & Predictive Analysis

Specific to your query:

APTARE StorageConsole provides you with a comprehensive list of media
expiring within a specified date range. The expiration date range for
the report can be configured to meet your needs.

The resulting exportable Media Summary Report includes the following
data: media ID, type, status, management server, volume pool, volume
group, estimated capacity, written mbytes, capacity available, percent
available, expiration date, slot #, last read date, and last written
date.
 
The Media Summary Report can be generated by management server, tape
library or volume group to provide you with the level of granularity
which you require. 

If you or anyone else would like to play with the product, please send
an email to demo AT aptare DOT com with the words "Demo Account" in the
subject, and
you will receive a login account to a production demo environment where
you can take a test-drive.

Best Regards,

Josh Collins

.
Message: 1
Date: Thu, 8 Apr 2004 09:57:14 +0100 (BST)
From: "=?iso-8859-1?q?Feroz=20F.=20Basir?=" <dbase77 AT yahoo DOT com>
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] list of media going to expire in specific date
range

Hi all,

Is there a way we can query catalog db to get a list
of media that going to expire in given date range? I
know I can get a list of media using "bpimagelist"
command. But it wont give me by expire date.

Thank you in advance.

regards,
feroz