John,
You could use a sql select statement on the table contents, jl. if tapename is tape001:
select distinct node_name from contents where (volume_name like "tape001")
This shows you all of the nodenames that haves data on the tape.
Or if you like a long, long, LONG coffeebreak:
select * from contents
:-) give you every file on every tape with a lot of detail
The columns of the table contents are:
volume_name, node_name, type, filespace_name, file_name, aggregated, file_size,
segment and cached
A list of all the tables:
select * from tables
You can use the sql select statements on the tsm command line (also in the admin web
client) and in scripts, you can find with this statements everything you want.
Good Luck,
Maurice
The Netherlands
----- Original Message -----
From: "Mills, John" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 2:40 PM
Subject: Verifying Tape Contents
> All,
> I have a script that tells me every tape
> that has been checked out of our library in
> the past 24 hours. I have been trying to
> refer back to what was backed up to each tape.
> I don't really mean file list. I mean simply
> what node or if it was the TSM DB backup. I've
> been through the activity log and the best I
> can do is nail down what time the tape was
> mounted. The only way I know to do this is
> to artificially populate the log with session
> information when anything is mounted. Since
> that would be problematic, is there another way?
>
> John Mills
>
