I would like to thank everyone for the information on getting a list of
tables and fields for ADSM.

New question.  About every 9 months we have been buying bigger hard drives
just to hold the ADSM database.  We are basically running ADSM out of the
box.  No fine tuning of setup.  We retain 90 versions of active and inactive
files with retention set up unlimited.  This is obviously too much.  (That
I've already discussed with the administrator.)

What I wish to do is struct a query to list those files that are recoverable
for files that have been deleted off our file system.  Below is what the
vendor provided, however, I read it as giving a list of files that are
"inactive" which does not equate to deleted.  How can I limit the query to
only those files that have been deleted?

thanks


select FILESPACE_NAME as "MtPt",HL_NAME as "Path",LL_NAME as "Filename", -
date(BACKUP_DATE) as "Date" from backups where -
state='INACTIVE_VERSION' and node_name='477BARD' -
order by FILESPACE_NAME, HL_NAME, LL_NAME asc > /bard1/tsm/xxxx_log
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com