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 [email protected] ============ "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:[email protected]] On Behalf Of >Roger Deschner >Sent: Thursday, February 12, 2009 1:16 PM >To: [email protected] >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 [email protected] > Academic Computing & Communications Center >======I have not lost my mind -- it is backed up on tape somewhere.===== >
