Nice. Is it anywhere list of undocumented 'show something' list? On 3/11/06, Josh-Daniel Davis <[EMAIL PROTECTED]> wrote: > These are pulled by the server during startup and stored in temporary > tables that are inaccessible by SQL commands. > > You can get the WWN from SHOW LIBR. > > -Josh > > > > On 06.03.10 at 07:56 [EMAIL PROTECTED] wrote: > > > Date: Fri, 10 Mar 2006 07:56:52 -0800 > > From: T. Lists <[EMAIL PROTECTED]> > > Reply-To: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> > > To: ADSM-L@VM.MARIST.EDU > > Subject: What table is the "q drive" WWN and Serial number stored in? > > > > 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 > > >
-- --w
