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.