Need to obtain drive utilisation report

Hiten

Unregistered / Unconfirmed
Joined
Sep 14, 2010
Messages
99
Reaction score
0
Points
0
Location
I am living in Mumbai.
PREDATAR Control23

Hi All,
I have TSM version 6.4.3 and using TSM Operational Reporting - Version 5, Release 5, Level 7.0. Since my number of backup nodes getting increased, i need to plan for additional tape library as i found current tape library of LTO5 with 4 drives insufficient. I need to present the drive utilization report to the management with each drive utilize for how many hours within 24hrs but i could not get clue how to fetch the same. Can some one help me if any query by which i can generate the report.
 
PREDATAR Control23

Check Thobas TSM SQL page https://thobias.org/tsm/sql/ search for tapes
maybe you can try something like this if you have 8 drives, youput is grouped by date (I have not tried this )

select sum(end_time-start_time)/8 ,date(start_time) from summary where activity='TAPE MOUNT' group by date(start_time)
 
PREDATAR Control23

SP Studio by Spirit Software has some neat builtin queries that can export to a PDF. https://www.spiritsoftware.biz/tsm-studio/
I've used it in the past.
Could also do something like this:

SELECT START_TIME, END_TIME, DRIVE_NAME, VOLUME_NAME FROM SUMMARY WHERE ACTIVITY='TAPE MOUNT' AND START_TIME BETWEEN '<date stamp>' AND '<ending date stamp>' and parse it out with your favorite charting tool.
 
Top