Try . . . select * from events where '11/22/2002 < scheduled_start
Change the date as necessary and add any other constraints (e.g. node_name='mynode'). Mahesh >>> [EMAIL PROTECTED] 11/22/02 08:36AM >>> 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 **********************************************************************