This should work :
select drives.drive_name, -
paths.device, -
drives.drive_state, -
paths.online, -
drives.allocated_to -
from drives,paths -
where drives.drive_name=paths.destination_name
Guillaume Gilbert
Storage Architect
Storage Group, Sun Microsystems
guillaume.gilbert AT sun DOT com
514.866.8876 Office
514.290.6526 Cell
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Rhodes
Sent: September 6, 2006 09:44
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] library manager mounted volumes - which client
instance are they for?
>From a TSM library manager instance, is there a way to tell which mounts
(q
mount)
are related to a particular TSM library client instance?
A "q mount" lists the volumes mounted, and a "q libvol" for those
volumes would show the owning instance . . . . but I'm thinking there
must be a more direct way.
Thanks
Rick
-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If the
reader of this message is not the intended recipient or an agent
responsible for delivering it to the intended recipient, you are hereby
notified that you have received this document in error and that any
review, dissemination, distribution, or copying of this message is
strictly prohibited. If you have received this communication in error,
please notify us immediately, and delete the original message.
|