Why not try the TAPE MOUNT rows from the SUMMARY table? Gives you the start/end time of each tape mount, the drive it was moutned on and the tape volume name. This will probably include the mount retenetion time for the devclass.
select * from summary where activity='TAPE MOUNT' Bill Boyer "I saw screens of green, red messages too, then came blue, shubidu And i think to myself, what a wonderful world " - ?? -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Akash Jain Sent: Thursday, February 17, 2005 4:25 AM To: [email protected] Subject: Re: 3584 Tape Drive Usage Information Will the same script work on solaris also? Regards Akash Jain -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Hooft, Jeroen Sent: Thursday, 17 February 2005 2:39 PM To: [email protected] Subject: Re: 3584 Tape Drive Usage Information See attached the script we use for this purpose. starts from cron every 10 minutes. R Jeroen -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Behalf Of Sung Y Lee Sent: woensdag 16 februari 2005 22:30 To: [email protected] Subject: 3584 Tape Drive Usage Information Howdy folks, In 3584 Library with LTO drives, is there a way to find out tape drives utilization information? How long the tape has been used(not idle state) per drive? Not from TSM, but more like from OS level. This is for AIX. But if you have some sort of select command from TSM that would be wonderful also. I am looking into creating kinda of report that displays Drive#, Used Duration, Period. Thank you. Sung Y. Lee
