Even if I boost the number of hours in your select to 60, I still only get today's events.
Am I correct in assuming that when I use "query event" the data I receive is from the events table that I'm running select against? Mahesh Tailor <MTailor@CARI To: [EMAIL PROTECTED] LION.COM> cc: Sent by: Subject: Re: select * from events - only today's events "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] RIST.EDU> 11/21/2001 03:23 PM Please respond to "ADSM: Dist Stor Manager" Ken, Try this . . . select node_name,status from events where status!='Completed' and domain_name!='' and \ cast((current_timestamp-actual_start)hours as decimal(8,0))<19 and \ '$DATE' < scheduled_start order by node_name In this case $DATE is a variable that stores the date (computed using DATE ="$MONTH/$DAY/$YEAR") and cast((current_timestamp-actual_start)hours as decimal(8,0))<19 catches all events in the past 19 hours. Hope this helps. >>> [EMAIL PROTECTED] 11/21/01 02:52PM >>> Gabriel, the query event part works fine, I'm able to see historical event data. It is when using select, which is more useful than query when feeding data to scripts, that I can't get history. I assume that selecting from the events table should provide the same data as using query event. Thanks... Ken Gabriel Wiley <[EMAIL PROTECTED] To: [EMAIL PROTECTED] M.COM> cc: Sent by: Subject: Re: select * from events - only today's events "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] RIST.EDU> 11/21/2001 01:21 PM Please respond to "ADSM: Dist Stor Manager" Ken, Try this "q ev * * begind=xx endd=today" xx = how many days back do you want to go.... If you want to see only failures add "ex=y" to the end of the statement. There is also begint = begin time endt = end time Gabriel C. Wiley ADSM/TSM Administrator AIX Support Phone 1-614-308-6709 Pager 1-877-489-2867 Fax 1-614-308-6637 Cell 1-740-972-6441 Siempre Hay Esperanza Ken Long <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 11/21/2001 01:00:38 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: select * from events - only today's events Am I missing something? I have Eventretention set to 90 days. I can use "query event" to see event data from days past. But if I use "select * from events" I only get events from today, no historical data. Shouldn't the Events table have previous days results in it? Thanks... Ken