The events table is a temporary table that is recalculated as needed. The default is to do only the current day.
Try adding a "where" clause like: Select * from events where scheduled_start>'2008-04-01 00:00' This will bring up old data. Orville L. Lantto Storage Consultant -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of James Hunt Sent: Friday, April 04, 2008 5: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
