Here's a sample SELECT statement that will show you the type of data you can get from the SUMMARY table. You can modify it to include END times as well as start times, or limit it to the past 24 hours, etc.
If you want to do any detailed analysis, I would run it in -commadelimited mode and save the data into a file, then do the stats with a spreadsheet. select date(start_time) as date, time(start_time) as time, char(library_name,12) as "Lib", char(drive_name,20) as "Drive", char(volume_name,8) as "Vol", char(successful,5) as "OK" from summary where activity='TAPE MOUNT' -----Original Message----- From: Alfred G Welch [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 12:03 PM To: [EMAIL PROTECTED] Subject: Average Mounts with mtlib command or select statement? TSMers, I have a 3494 library and need to compile information on number of mounts the library has done. It doesn't have to be any certain drives or volumes. A total would work or if it could be broken down to specifics. Is there a mtlib command or select statement that anyone knows of that I could use? Any help would be thankful
