The said query does not give me the date/time stamp. I can find out when
the said tape was mounted from summary table and for how long,
 but the manual process of comparing could take up too much time.

Raminder



Lawrence Clark <Larry_Clark AT THRUWAY.STATE.NY DOT US>
08/20/2003 04:24 PM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: Which tape was written to by which node.





something like:
select * from volumeusage where node_name="node" and
stgpool_name="stgpool"

>>> Raminder.Braich AT DAVEY DOT COM 08/20/03 04:13PM >>>
Hi,
             We run TSM 4.1.2 on a Windows 2000 machine. The library
is
3494 with 4 3590 E1A drives.    I want to track the tape drive usage
on
our system. e.g. for how long did a particular node take to backup and
to
which volume(s), and in turn on which drives were those volumes
mounted. I
can get the tape mounts from summary table but it does not tell me
which
nodes wrote to it. Till now I am able to find only two of the three
things
namely which node wrote to the tape, which drives were the tapes
mounted
and how long did it take to backup. Is there a way to find these three
things with a query?

Thanks
Raminder Braich