ADSM-L

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

2006-03-13 03:42:04
Subject: Re: What table is the "q drive" WWN and Serial number stored in?
From: "Large, M (Matthew)" <Matthew.Large AT RABOBANK DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Mon, 13 Mar 2006 08:41:27 -0000
You could always look here:

http://www.tsmwiki.com/tsmwiki/show?action=fullsearch&context=180&value=
show

Regards,
Matthew 

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Wojtek Piecek
Sent: 11 March 2006 00:56
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] What table is the "q drive" WWN and Serial number
stored in?

Nice. Is it anywhere list of undocumented 'show something' list?

On 3/11/06, Josh-Daniel Davis <xaminmo AT omnitech DOT net> 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 tracylists AT YAHOO DOT COM wrote:
>
> > Date: Fri, 10 Mar 2006 07:56:52 -0800
> > From: T. Lists <tracylists AT YAHOO DOT COM>
> > Reply-To: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> > To: ADSM-L AT VM.MARIST DOT 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
_____________________________________________________________

This email (including any attachments to it) is confidential, legally 
privileged, subject to copyright and is sent for the personal attention of the 
intended recipient only. If you have received this email in error, please 
advise us immediately and delete it. You are notified that disclosing, copying, 
distributing or taking any action in reliance on the contents of this 
information is strictly prohibited. Although we have taken reasonable 
precautions to ensure no viruses are present in this email, we cannot accept 
responsibility for any loss or damage arising from the viruses in this email or 
attachments. We exclude any liability for the content of this email, or for the 
consequences of any actions taken on the basis of the information provided in 
this email or its attachments, unless that information is subsequently 
confirmed in writing. If this email contains an offer, that should be 
considered as an invitation to treat.
_____________________________________________________________

<Prev in Thread] Current Thread [Next in Thread>
  • Re: What table is the "q drive" WWN and Serial number stored in?, Large, M (Matthew) <=