This was discussed on the list only once since I am subscribed but much
more in the past. You can dig into www.adsm.org archives and find it.
It might be interesting to read an answer Andrew Raibeck was posted more
than year ago (http://msgs.adsm.org/cgi-bin/get/adsm0009/619.html).
Yes, I know this is not standard-compliant SQL implementation, does
implement just subset of SQL commands. However such select behavior is too
proprietary from my point of view.
Is there anyone tried to open PMR on this (even just to get "Works as
designed") ?

Zlatko Krastev
IT Consultant





Ken Long <ken.long AT WHEDA DOT COM> on 22.11.2001 01:47:05
Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
To:     ADSM-L AT VM.MARIST DOT EDU
cc:

Subject:        Re: select * from events - only today's events

Thanks... I was just coming to that conclusion myself

I finally got Crystal Reports to understand the timestamp fields (requires
the TSM 4.1.3 ODBC driver, TSM 4.2.1 ODBC driver doesn't work with Crystal
Reports 8.0).  Crystal could see all of the data, where select * couldn't.

I understand the desire to make it work like Q Events does, but for those
of us new to using select/SQL it is unexpected.  Select * should select all
records, like it does for other tables.

Thanks again to the extremely valuable resources using this forum!





                    "Rushforth, Tim"
                    <[email protected]        To: ADSM-L AT VM.MARIST DOT EDU
                    PEG.MB.CA>                  cc:
                    Sent by: "ADSM: Dist        Subject:     Re: select *
from events - only today's events
                    Stor Manager"
                    <ADSM-L AT VM.MARIST DOT ED
                    U>


                    11/21/2001 04:49 PM
                    Please respond to
                    "ADSM: Dist Stor
                    Manager"






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:   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