Christian
The command I am entering is

select file_name form contents where node_name='Sprint800"

Is this correct? It is taking very long is there another way to find
these files?

Thanks for your help!

Christian Demnitz wrote:

> Timothy
>
> yes, you can use this command on the tsm server command line!
>
> Christian Demnitz
>
> Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
> Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 08.11.2004 15:15
> Bitte antworten an
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> An
> ADSM-L AT VM.MARIST DOT EDU
> Kopie
>
> Thema
> Re: Antwort: Re: Antwort: How would I check to see if files are on
> tapealready?
>
> Christian,
>
> Can enter this command on the server command line?
>
> Christian Demnitz wrote:
>
> > ok, try this:
> >
> > select file_name from contents where node_name='xxx'
> >
> > Christian Demnitz
> >
> > Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
> > Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > 08.11.2004 14:42
> > Bitte antworten an
> > "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> >
> > An
> > ADSM-L AT VM.MARIST DOT EDU
> > Kopie
> >
> > Thema
> > Re: Antwort: How would I check to see if files are on tape already?
> >
> > I don't know what tape the files are on but I know
> > the node? Sorry for the lack of Information.
> >
> > Thanks
> >
> > Christian Demnitz wrote:
> >
> > > q content <vol_name>
> > > or
> > > select * from contents (select xxx from contents where
> "vol_name"="xxx")
> > > and so on!
> > >
> > > but be carefully! takes very long time, shows every file on this tape!
> > >
> > > Christian Demnitz
> > >
> > > Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
> > > Gesendet von: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > > 08.11.2004 14:16
> > > Bitte antworten an
> > > "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > >
> > > An
> > > ADSM-L AT VM.MARIST DOT EDU
> > > Kopie
> > >
> > > Thema
> > > How would I check to see if files are on tape already?
> > >
> > > How would I check to see if files are on tape already?
> > > Using TSM.
> > >
> > > Thanks in advance