Andy and all,
Your suggestion worked great!!(select * from events where scheduled_start
between '2001-02-20 00:00:00' and '2001-02-22 23:59:59'). I am using the
ODBC to return the information to an Excel spreadsheet. Where as before I
was getting just today's info, now the results look just like
> 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..
ng <[EMAIL PROTECTED]> on 22.11.2001 01:47:05
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: select * from events - only today's events
Thanks... I was just coming to that conclusion myself
I finally
;Rushforth, Tim"
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
PEG.MB.CA> cc:
Sent by: "ADSM: Dist Subject: Re: select * from events
- only today's events
Stor Manager&qu
Ken:
Select * from events only shows events for the current day.
See http://msgs.adsm.org/cgi-bin/get/adsm0009/619.html for an explanation.
Tim Rushforth
City of Winnipeg
To: [EMAIL PROTECTED]
cc:
Subject: select * from events - only today's events
Am I missing something?
I have Eventret
cc:
Sent by: Subject: Re: select * from events - only
today's events
"ADSM: Dist
Stor Manager"
<[EMAIL PROTECTED]
RIST.EDU>
Gabriel Wiley
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
M.COM> cc:
Sent by: Subject: Re: select * from events - only
today's events
"ADSM: Dist
uery event.
Thanks... Ken
Gabriel Wiley
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
M.COM> cc:
Sent by: Subject: Re: select * from events - only
today's events
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 Suppo
