Thanks Bill! (and also Fred Johanson of uchicago.edu for a simpler one)
That's just what I was looking for, and now I don't have to reinvent it.

Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu
============ "In theory, theory and practice are the same, =============
========= but in practice, theory and practice are different." =========

On Thu, 12 Feb 2009, Colwell, William F. wrote:

>Roger,
>
>I have a script called 'qdr' to show the drives and the tapes on each.
>The script also
>executes scripts in the library manager client servers to get details of
>the usage.
>
>The scripts and sample output are in the attached file.
>
>Hope this helps,
>
>Bill Colwell
>Draper Lab
>
>
>
>-----Original Message-----
>From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
>Roger Deschner
>Sent: Thursday, February 12, 2009 1:16 PM
>To: ADSM-L AT VM.MARIST DOT EDU
>Subject: SQL SELECT to show what's mounted and why
>
>I'm looking for an SQL SELECT that will display a list of what tape is
>mounted on each drive, and which session or process it's mounted for.
>
>I've looked at SHOW ASMOUNTED, SHOW ASVOL, SHOW MP and they don't really
>do it.
>
>I'm dealing with a drive-constrained system and no budget to add
>drives, so I'm trying to manage the situation with better automation.
>
>Roger Deschner      University of Illinois at Chicago     rogerd AT uic DOT edu
>               Academic Computing & Communications Center
>======I have not lost my mind -- it is backed up on tape somewhere.=====
>