select * from adsm.backups where node_name='client_name' and
ll_name='file_name'

you may wish to further narrow down the search by using
filespace_name='blah' and hl_name='blah'
and filespace is just that and the high_level name is the directory path

later,
      DWight

> ----------
> From:         Van Ruler, Ruud R
> SSI-TSEA-332[SMTP:Ruud.R.vanRuler AT IS.SHELL DOT COM]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Tuesday, February 01, 2000 8:49 AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      number of backup versions
>
> Hi gurus
>
> this question may be asked several times but still .......
> "how, from the os/390 adsm server point of view, can I check the number of
> versions
> (active and inactive) of a specific file (for a specific node/client)
> ????
>
> in the STANDARD backup copy group I have specified "Versions Data Exists 4
> "
> and I want to check if there a 4 versions or less and not more than 4
> !!!!!
>
> =======================================================
>              Ruud van Ruler
> Shell Services International BV - ISES/32
> Our Data Storage Management home page: http://sww2.shell.com/dstorage/
> > Room 2A/D07
> > Dokter van Zeelandstraat 1, 2285 BD Leidschendam NL
> Tel : 070 - 3034644  /  Fax : 070 - 3034012
> Email Internet: ruud.r.vanruler AT is.shell DOT com
>                           r_van_ruler AT compuserve DOT com
> Email X400:/S=vanRuler /I=R /C=GB /A=GOLD /P=Shell /O=IS
>
>
>                                                             R.vanRuler
> ================================================================
>