> select file_name form contents where node_name='Sprint800" 'Sprint800' probably wont work, it has lowercase in it. (not positive though) Try SPRINT800.
But, I would narrow it down a bit more. First find what tape it may be on: select volume_name from volumeusage where node_name='SPRINT800' and stgpool_name='YOURPOOLNAME' and filespace_id=idnumber then for each tape volume name: select file_name from contents where volume_name='volname' and node_name='SPRINT800' and filespace_id=idnumber and file_name like 'directory filename' The format of the file_name search is probably the toughest to get right if you don't know what directory it is in. ALso if it is Windows, make sure it is upper case, if Unix get the case correct. You could run "select file_name from contents where ..." without the 'file_name' part and > it to a file and look there later. or use 'q content volumename f=d > file' to a file nd look in the file Matt Glanville Christian Demnitz <christian.demnitz@ To: [EMAIL PROTECTED] SINIUS.COM> cc: Sent by: "ADSM: Subject: Antwort: Re: Antwort: Re: Antwort: Re: Antwort: How would I check to Dist Stor Manager" see if filesare on tapealready? <[EMAIL PROTECTED] DU> 11/08/04 10:05 AM Please respond to "ADSM: Dist Stor Manager" Hi, I dont't know another way! Christian Demnitz Timothy Hughes <[EMAIL PROTECTED]> Gesendet von: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 08.11.2004 16:00 Bitte antworten an "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> An [EMAIL PROTECTED] Kopie Thema Re: Antwort: Re: Antwort: Re: Antwort: How would I check to see if filesare on tapealready? 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 <[EMAIL PROTECTED]> > Gesendet von: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > 08.11.2004 15:15 > Bitte antworten an > "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > An > [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > > Gesendet von: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > 08.11.2004 14:42 > > Bitte antworten an > > "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > > > An > > [EMAIL PROTECTED] > > 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 <[EMAIL PROTECTED]> > > > Gesendet von: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > > 08.11.2004 14:16 > > > Bitte antworten an > > > "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> > > > > > > An > > > [EMAIL PROTECTED] > > > 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