I think problem is not in query format:
"select * from events" only information for current day.
In addition, most possible "q events" takes data from table SUMMARY, not from
EVENTS.
By the way, I am not sure I am right.
From: ADSM: Dist Stor Manager [ad
The Events table is an odd duck (remember that SQL is a meta layer on top of a
B-tree db in TSMv4,5) where performing a function on its timestamps will cause
your quandry. Instead, try a construct like:
select * from events where scheduled_start <= (current_timestamp-12 hours)
Richard Sim
Fraustratingly, you'll need to use an absolute date (rather than relative date
as below) when selecting from the events table.
/David Mc
--Original Message--
From: Guenther Bergmann
Sender: ADSM: Dist Stor Manager
To: ADSM-L@VM.MARIST.EDU
ReplyTo: ADSM: Dist Stor Manager
Subject: [ADSM-
