Paul,

I recently needed this same info, so I wrote a Rexx program to take the results 
of a TSM SQL command and use the data to graphically plot tape drive 
utilization for all drives across a given span of time.  Although we use Aix 
for our TSM server, the Rexx program runs on our OS/390 mainframe.  If you are 
interested, reply direct to me and I can send you the jcl, rexx code, etc.  The 
program is < 200 lines, but makes heavy use of dynamic, multi-dimensional 
arrays, so you would need to be fairly proficient in Rexx to do much de-coding.

Steve Schaub
Haworth, Inc
email: Steve.Schaub AT Haworthinc DOT com

>>> AlexPaschal AT FREIGHTLINER DOT COM 04/25 12:51 PM >>>
Paul,

I tried:
dsmadmc -id=id -pa=password -comma -out=x:\tempdir\mountlog.mount q act
begind=-1 endd=-1 begint=00:00 endt=23:59 msg=8337
dsmadmc -id=id -pa=password -comma -out=x:\tempdir\mountlog.dismount q act
begind=-1 endd=-1 begint=00:00 endt=23:59 msg=8468

I then opened both files with Excel, set it to delimited by comma and space,
then deleted all the columns I didn't need, copied one file and pasted on
the end of the other, and sorted by drive then date/time, and came up with
the following (just an exerpt, of course).  This took about 5 minutes.

4/24/01 15:30 102200 mounted       rmt1
4/24/01 15:37 102200 dismounted    rmt1
4/24/01 20:55 100702 mounted       rmt1
4/24/01 21:17 100702 dismounted    rmt1
4/24/01 15:28 102074 mounted       rmt10
4/24/01 15:30 102074 dismounted    rmt10
4/24/01 15:37 101222 mounted       rmt11
4/24/01 15:38 101222 dismounted    rmt11

If you need to automate it, this may be doable with SQL and it'd definitely
be doable with AWK, and PERL.  Maybe SED.

Alex Paschal
Storage Administrator
Freightliner, LLC
(503) 745-6850 phone/vmail