select volume_name from contents where node_name like '%nodename%' and FILESPACE_NAME like '%Filespacename%' and FILE_NAME like '%Filename%'
On Wed, Jun 29, 2011 at 3:48 PM, molin gregory <[email protected]>wrote: > Hello, > > Try : q nodedata NODENAME stg=XXXX > > Cordialement, > Grégory Molin > Tel : 0141628162 > [email protected] > > -----Message d'origine----- > De : ADSM: Dist Stor Manager [mailto:[email protected]] De la part de > Tim Brown > Envoyé : mercredi 29 juin 2011 14:40 > À : [email protected] > Objet : [ADSM-L] volumes associated with a node > > Is there a select statement that will list all tape volumes that have files > for > > a given TSM node. > > > > Thanks, > > > > Tim Brown > Systems Specialist - Project Leader > Central Hudson Gas & Electric > 284 South Ave > Poughkeepsie, NY 12601 > Email: [email protected] <<mailto:[email protected]>> > Phone: 845-486-5643 > Fax: 845-486-5921 > Cell: 845-235-4255 > > > > > This message contains confidential information and is only for the intended > recipient. If the reader of this message is not the intended recipient, or > an employee or agent responsible for delivering this message to the intended > recipient, please notify the sender immediately by replying to this note and > deleting all copies and attachments. > > "ATTENTION. > > Ce message et les pièces jointes sont confidentiels et établis à > l'attention exclusive de leur destinataire (aux adresses spécifiques > auxquelles il a été adressé). Si vous n'êtes pas le destinataire de ce > message, vous devez immédiatement en avertir l'expéditeur et supprimer ce > message et les pièces jointes de votre système. > > This message and any attachments are confidential and intended to be > received only by the addressee. If you are not the intended recipient, > please notify immediately the sender by reply and delete the message and any > attachments from your system. " > -- Thanks & Regards, Sarav +974-3344-1538 There are no secrets to success. It is the result of preparation, hard work and learning from failure - Colin Powell
