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'
|