What you are looking for is in the summary table.  You can issue a
'select * from summary' to dig further form there.


--
Joshua S. Bassi
IBM Certified - AIX 4/5L, SAN, Shark
Tivoli Certified Consultant -ADSM/TSM
eServer Systems Expert -pSeries HACMP

AIX, HACMP, Storage, TSM Consultant
Cell (831) 595-3962
jbassi AT ihwy DOT com

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Charakondala, Chandrasekhar R.
Sent: Friday, November 22, 2002 5:37 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: select command to get old scheduled events


Hi All,

How can I get old scheduled events using select commands, I can get the
same using 'q event' but when I execute 'select * from events'  I am
getting only the latest events on scheduled backup.

Thanks in advance,

chandrasekhar








**********************************************************************
This message and any attachments are intended for the individual or
entity named above. If you are not the intended recipient, please do not
forward, copy, print, use or disclose this communication to others; also
please notify the sender by replying to this message, and then delete it
from your system.

The Timken Company
**********************************************************************