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 [EMAIL PROTECTED] -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Alex Paschal Sent: Friday, April 04, 2008 5:45 PM To: [email protected] 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:[EMAIL PROTECTED] On Behalf Of James Hunt Sent: Friday, April 04, 2008 3:12 PM To: [email protected] 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.
