This one is an "old chestnut", check out this link: http://www.mail-archive.com/[email protected]/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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[email protected]> 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 > [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.
