ADSM-L

Re: Average Mounts with mtlib command or select statement?

2002-05-24 13:16:43
Subject: Re: Average Mounts with mtlib command or select statement?
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
Date: Fri, 24 May 2002 13:14:57 -0400
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'



<Prev in Thread] Current Thread [Next in Thread>