ADSM-L

What table is the "q drive" WWN and Serial number stored in?

2006-03-10 10:59:54
Subject: What table is the "q drive" WWN and Serial number stored in?
From: "T. Lists" <tracylists AT YAHOO DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Fri, 10 Mar 2006 07:56:52 -0800
Q drive gives a WWN and serial number, however if you
just select from the DRIVES table you don't get that. 
What table is that information stored in?

tsm: TSM02>q drive * drive01 f=d

            Library Name: 3584LIB
            Drive Name: DRIVE01
            Device Type: LTO
            On-Line: Yes
            Read Formats:
ULTRIUM2C,ULTRIUM2,ULTRIUMC,ULTRIUM
            Write Formats:
ULTRIUM2C,ULTRIUM2,ULTRIUMC,ULTRIUM
            Element: 270
            Drive State: EMPTY
            Allocated to:
         *  WWN: 500507630001F012
         *  Serial Number: 9110108472
            Last Update by (administrator): STACY
            Last Update Date/Time: 03/09/06   16:16:17
            Cleaning Frequency
(Gigabytes/ASNEEDED/NONE): NONE


tsm: TSM02>select * from drives where
drive_name='DRIVE01'

  LIBRARY_NAME: 3584LIB
    DRIVE_NAME: DRIVE01
   DEVICE_TYPE: LTO
        ONLINE: YES
  READ_FORMATS: ULTRIUM2C,ULTRIU
 WRITE_FORMATS: ULTRIUM2C,ULTRIU
       ELEMENT: 270
  ACS_DRIVE_ID:
   DRIVE_STATE: EMPTY
  ALLOCATED_TO:
LAST_UPDATE_BY: STACY
   LAST_UPDATE: 2006-03-09 16:16:17.000000
    CLEAN_FREQ:
  DRIVE_SERIAL:



__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

<Prev in Thread] Current Thread [Next in Thread>