Hi Geoff,
there isn't one command to do this, but a select and then 1 or 2 show commands will find the volume name. Here is an example. tsm: WIN2>select object_id from backups where node_name = 'A-NODE-NAME' and ll_name = 'OUTLOOK.PST' OBJECT_ID --------------------- 590316 tsm: WIN2>show bfo 590316 Bitfile Object: 590316 Active **Archival Bitfile Entry Bitfile Type: PRIMARY Storage Format: 22 Bitfile Size: 10480218 Number of Segments: 1, flags: 0 Storage Pool ID: 8 Volume ID: 127 Volume Name: /tsm_nx331/win2/0000007F.BFS tsm: WIN2>show invo 590316 Inventory object 590316 of copy type Backup has attributes: NodeName: A-NODE-NAME, Filespace(1): \\a-node-name\c$, ObjName: \USERS\A-NODE-NAME\APPDATA\LOCAL\MICROSOFT\OUTLOOK\OUTLOOK.PST. hlID: 0292E2463557C3F93E61EB8A7821EA1BE364A261 llID: 93534B77D3C2BC010BCA14FAF8EB123DC0ED5D7B Type: 2 (File) MC: 18 (OUTLOOK3) CG: 1 Size: 32016384 HeaderSize: 0 Active, Inserted 03/06/2012 11:25:28 AM (CUT Not Set) GroupMap 00000000, bypassRecogToken NULL Bitfile Object: 590316 Active **Archival Bitfile Entry Bitfile Type: PRIMARY Storage Format: 22 Bitfile Size: 10480218 Number of Segments: 1, flags: 0 Storage Pool ID: 8 Volume ID: 127 Volume Name: /tsm_nx331/win2/0000007F.BFS Sometimes the 'show bfo' is suffiecient and sometimes the 'show invo' is required depending on if the file is in an aggregate or by itself. I have used this process too many time to find files which should not have been backed up and thoroughly expunge all traces of them. You will probably need to expand the select to distinguish active and inactive versions and to improve performance on version 5 servers. On version 6 servers just supplying the ll_name is very quick. Bill Colwell Draper Lab -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Geoff Gill Sent: Thursday, June 28, 2012 8:38 PM To: ADSM-L@VM.MARIST.EDU Subject: select or other command Hello, Over the years I've saved a lot of commands but never saw one for this. I'm not sure if it is possible but I thought I'd ask to see if anyone has it. Is it possible to create a select command that I input the name of a file that was backed up and have the output tell me what tape(s) it would be on? I have a command that will tell me all the tapes a node has data on, and another to spit out the contents of a tape to a file, and from there search for the filename but I'm curious if there is an easier way. Thank You Geoff Gill