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