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
                    <wileyg AT US DOT IB        To:     ADSM-L AT VM.MARIST DOT 
EDU
                    M.COM>               cc:
                    Sent by:             Subject:     Re: select * from events 
- only today's events
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    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 <ken.long AT WHEDA DOT COM>@VM.MARIST.EDU> on 11/21/2001 01:00:38 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
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