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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
James Hunt
Sent: Friday, April 04, 2008 5: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