I'm not sure on how you would form the query (exactly) but something along
the lines of
select distinct filespace_name, hl_name, ll_name from adsm.backups where
node_name='blah''
then take the output from that and for each line do a query
select filespace_name, hl_name, ll_name from adsm.backups where
node_name='blah'' AND state='ACTIVE_VERSION'

any files you DON"T get a hit on are "deleted files from the client box"

there is probably some fancy to do this with SQL (better than building a
billion queries) but I'm a little lost there...

Dwight


> ----------
> From:         wawork Wash[SMTP:wawork AT HOTMAIL DOT COM]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Friday, July 14, 2000 1:17 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      ADSM data model query question.
>
> 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
>