Re: [ADSM-L] select or other command

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 AT VM.MARIST DOT EDU] On Behalf Of 
Geoff Gill
Sent: Thursday, June 28, 2012 8:38 PM
To: ADSM-L AT VM.MARIST DOT 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