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
|