Here's a select/script that I use to pull that info...not perfect, but it does the job.
You'll have to change the devclass name to match what you are using: DEFINE SCRIPT SHOWME_SESSION_MOUNTS DESC="Show sequential vols in use by a session" "/* Show Tape mounts: */" "set sqldisplaymode narrow" "select -" "client_name as ""Client"", -" "session_id as ""Session"", -" "substr(output_vol_access,3,6) as ""Tape Volume"" -" "from sessions -" "where -" "output_vol_access is not null and -" "substr(output_vol_access,3,6) -" "in -" "(select -" "volume_name from volumes -" "where devclass_name in -" "(select -" "devclass_name from devclasses -" "where lower(devtype) like 'lto'-" ")-" ")" "/* Show File Mounts: */" "set sqldisplaymode wide" "select -" "client_name as ""Client"", -" "session_id as ""Session"", -" "left(substr(output_vol_access,3,90), - " "posstr(substr(output_vol_access,3,90),',-') -1) -" "as ""File Volume"" -" "from sessions -" "where -" "output_vol_access is not null and -" "left(substr(output_vol_access,3,90), -" "posstr(substr(output_vol_access,3,90),',-') -1) -" "in -" "(select -" "volume_name from volumes -" "where devclass_name in -" "(select -" "devclass_name from devclasses -" "where lower(devtype) like 'file'-" ")-" ")" Regards, -Lloyd On Sun, 09 Jan 2005 22:29:07 +0100 Martin Trcka <[EMAIL PROTECTED]> wrote thusly: > Hello list members, > is there a way to identify which session is holding particular drive ? > > I've been playing with "show asm, show asq" commands recently which > report some kind of session numbers in the output, but unfortunately > they do not match session IDs presented when issuing "q ses". > > Maybe I'm missing st. > > TIA, > > -- > > S pozdravem / Best Regards, > > Martin Trcka, IT Consultant > Tech. Support Department > GC System a.s., Spitalka 41, 60200 Brno, Czech Rep. > mob: +420 602 452 361 > fax: +420 543 537 333 > email: [EMAIL PROTECTED] --
