Thanks Matthew, Christian and Richard for your replies! I found what I was looking for!
Matthew Glanville wrote: > > 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
