All the suggestions that use bpdbjobs as the source of information are
overlooking the fact that Gary wants to see Drive utilization and guess
what, bpdbjobs doesn't carry that piece of information!  The other things
you cannot get from bpdbjobs is knowledge about tape/drive throughput on
jobs that span multiple tapes.  All you get is aggregate data that tells you
how many kb were written on behalf of the job and how long each tape was
mounted.  In our environment we regularly write 380+ Gb jobs to DLT, causing
us to use 3-4 tapes.  Sometimes one of those combinations performs poorly
but there is no way of knowing which one that was.
 
Hence, although I look at bpdbjobs output, to get a rough sense of what is
going on, the beef itself has to be retrieved from the MediaManagers' bptm
logs.  Those will tell you in great detail (although sometimes still not
enough :-) how drives and tapes behaved.
 
Since many folks seem to be needing this kind of data I will make my PERL
code to analyze this data available sometime over the weekend.  Anyone who
wants to be an early adopter and cannot wait until Monday, let me know and I
will send you an early tar-ball tonight when I get home:
mailto:pwinkeler AT pbnj-solutions DOT com <mailto:pwinkeler AT pbnj-solutions 
DOT com> 
 
Here is some sample output from a typical day's run of one of our larger
backup jobs highlighting the kind of problems bpdbjobs just doesn't help you
with.  Look at job stream 32050.  It wrote a total of 342Gb just like the
other streams for the NBUPR2 class but it ran for 26 hours as opposed to the
more typical 12.  The culprit turns out to be the 16 hours volume S02442
spent in drive 16, crawling along at a measly 1Mb/sec.  (This output was
generated using a script called "joblog.pl")

J:320247:29399:NBUPR2 Wed Mar 27 16:59:36 2002 342.74Gb in 12:26:02
(7.84Mb/s) status 0
M:320247:S03325 in 20 Wed Mar 27 17:02:20 2002 35.06Gb over 02:06:06 at
4.74Mb/s
M:320247:S03080 in 14 Wed Mar 27 19:11:40 2002 120.74Gb over 03:53:04 at
8.84Mb/s
M:320247:S02409 in 12 Wed Mar 27 23:06:57 2002 108.04Gb over 03:36:41 at
8.51Mb/s
M:320247:S02990 in 17 Thu Mar 28 02:45:41 2002 78.90Gb over 02:39:24 at
8.45Mb/s
J:320248:29420:NBUPR2 Wed Mar 27 16:59:37 2002 342.56Gb in 11:59:49
(8.12Mb/s) status 0
M:320248:S03175 in 19 Wed Mar 27 17:01:34 2002 43.78Gb over 02:23:56 at
5.19Mb/s
M:320248:S03343 in 16 Wed Mar 27 19:29:44 2002 119.58Gb over 03:53:46 at
8.73Mb/s
M:320248:S02402 in 13 Wed Mar 27 23:25:35 2002 106.25Gb over 03:19:33 at
9.09Mb/s
M:320248:S02971 in 15 Thu Mar 28 02:47:20 2002 72.95Gb over 02:11:41 at
9.45Mb/s
J:320249:29430:NBUPR2 Wed Mar 27 16:59:37 2002 343.01Gb in 16:48:18
(5.81Mb/s) status 0
M:320249:S03283 in 18 Wed Mar 27 17:02:17 2002 43.95Gb over 02:25:47 at
5.15Mb/s
M:320249:S03418 in 20 Wed Mar 27 19:32:55 2002 120.91Gb over 03:59:30 at
8.62Mb/s
M:320249:S02620 in 14 Wed Mar 27 23:35:20 2002 82.04Gb over 07:15:59 at
3.21Mb/s
M:320249:S03446 in 13 Thu Mar 28 06:53:19 2002 96.10Gb over 02:54:08 at
9.42Mb/s
J:320250:29451:NBUPR2 Wed Mar 27 16:59:39 2002 343.03Gb in 26:24:41
(3.69Mb/s) status 0
M:320250:S02925 in 11 Wed Mar 27 17:02:09 2002 50.62Gb over 02:35:21 at
5.56Mb/s
M:320250:S03495 in 19 Wed Mar 27 19:40:46 2002 116.03Gb over 03:55:14 at
8.42Mb/s
M:320250:S02443 in 16 Wed Mar 27 23:39:00 2002 56.90Gb over 16:06:30 at
1.00Mb/s
M:320250:S02766 in 12 Thu Mar 28 15:47:33 2002 111.41Gb over 03:20:29 at
9.48Mb/s
M:320250:S02461 in 15 Thu Mar 28 19:10:08 2002 8.08Gb over 13:52 at 9.94Mb/s
J:320251:29478:NBUPR2 Wed Mar 27 16:59:40 2002 342.72Gb in 11:52:12
(8.21Mb/s) status 0
M:320251:S03425 in 14 Wed Mar 27 17:02:57 2002 3.54Gb over 20:11 at 2.99Mb/s
M:320251:S03426 in 15 Wed Mar 27 17:26:17 2002 118.69Gb over 04:20:04 at
7.79Mb/s
M:320251:S02391 in 11 Wed Mar 27 21:48:21 2002 111.92Gb over 03:37:20 at
8.79Mb/s
M:320251:S02583 in 19 Thu Mar 28 01:27:45 2002 107.69Gb over 03:19:25 at
9.22Mb/s
M:320251:S03435 in 12 Thu Mar 28 04:49:35 2002 903.22Mb over 01:51 at
8.07Mb/s
J:320252:29485:NBUPR2 Wed Mar 27 16:59:40 2002 342.99Gb in 16:04:51
(6.07Mb/s) status 0
M:320252:S03020 in 16 Wed Mar 27 17:03:09 2002 6.39Gb over 27:12 at 4.01Mb/s
M:320252:S03393 in 17 Wed Mar 27 17:33:26 2002 126.83Gb over 04:07:15 at
8.75Mb/s
M:320252:S02513 in 18 Wed Mar 27 21:42:39 2002 109.51Gb over 03:38:13 at
8.56Mb/s
M:320252:S02643 in 20 Thu Mar 28 01:23:34 2002 89.81Gb over 07:21:11 at
3.47Mb/s
M:320252:S03449 in 19 Thu Mar 28 08:46:45 2002 10.45Gb over 17:10 at
10.39Mb/s
J:320253:29511:NBUPR2 Wed Mar 27 16:59:42 2002 342.99Gb in 12:05:04
(8.07Mb/s) status 0
M:320253:S02940 in 15 Wed Mar 27 17:03:01 2002 1.18Gb over 09:14 at 2.19Mb/s
M:320253:S03130 in 12 Wed Mar 27 17:16:48 2002 126.35Gb over 04:37:29 at
7.77Mb/s
M:320253:S02408 in 17 Wed Mar 27 21:56:57 2002 106.84Gb over 03:37:53 at
8.37Mb/s
M:320253:S02943 in 18 Thu Mar 28 01:36:57 2002 108.62Gb over 03:27:20 at
8.94Mb/s
J:320254:29532:NBUPR2 Wed Mar 27 16:59:43 2002 343.01Gb in 12:02:33
(8.10Mb/s) status 0
M:320254:S02994 in 17 Wed Mar 27 17:04:04 2002 2.32Gb over 16:09 at 2.45Mb/s
M:320254:S03350 in 13 Wed Mar 27 17:24:26 2002 124.87Gb over 04:47:22 at
7.42Mb/s
M:320254:S02321 in 15 Wed Mar 27 22:13:55 2002 114.22Gb over 03:38:23 at
8.93Mb/s
M:320254:S02981 in 11 Thu Mar 28 01:54:20 2002 101.59Gb over 03:07:29 at
9.25Mb/s

PaulW