This one is an "old chestnut", check out this link:
http://www.mail-archive.com/adsm-l AT vm.marist DOT edu/msg61871.html
Best regards,
Andy
Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Product Development
Level 3 Team Lead
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com
IBM Tivoli Storage Manager support web page:
http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html
The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2008-04-04
17:20:34:
> That just lists the events table. I'm looking for the past events from
> the previous day.
>
> Jim Hunt
> Senior Consultant
> IBM Tivoli Storage Manager Certified
> _______
> GlassHouse Technologies, Inc.
> Parkville, MO 64152
> 816.547.4165 cell
> 816.505.2169 fax
> jhunt AT glasshouse DOT com
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> Alex Paschal
> Sent: Friday, April 04, 2008 5:45 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Which TSM tables contain
>
> Hi, Jim.
>
> This should do it for you.
>
> select tabname from syscat.tables where tabname like '%EVENT%'
>
> Have fun.
>
> ________________________________
> Alex Paschal
> Storage Solutions Engineer
> MSI Systems Integrators
> ________________________________
>
> Your Business. Better.
>
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf
> Of
> James Hunt
> Sent: Friday, April 04, 2008 3:12 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] Which TSM tables contain
>
> Which TSM table contains this information? I'm looking for a select
> statement to reproduce the same results.
>
>
>
> q event * t=a begind=today-1
>
>
>
> Jim Hunt
>
> Senior Consultant
>
> IBM Certified Deployment Professional -- Tivoli Storage Manager V5.2
>
>
>
> This message (including any attachments) is intended only for
> the use of the individual or entity to which it is addressed and
> may contain information that is non-public, proprietary,
> privileged, confidential, and exempt from disclosure under
> applicable law or may constitute as attorney work product.
> If you are not the intended recipient, you are hereby notified
> that any use, dissemination, distribution, or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, notify us immediately by telephone and
> (i) destroy this message if a facsimile or (ii) delete this message
> immediately if this is an electronic communication.
>
> Thank you.
|
