the
events table....
TABSCHEMA:
ADSM TABNAME: EVENTS
CREATE_TIME: 1996-04-25 14:31:19.025065
COLCOUNT: 8 INDEX_COLCOUNT: 1 UNIQUE_INDEX:
FALSE REMARKS: Scheduled Event
Results
I keep 7 days in the actlog - the event
log must have the data - as you can do a query past one day using begind and
begint.
Does anyone know the tables used in the q
events command?
Jane
%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Jane Bamberger
IS Department
Bassett Healthcare
607-547-4784
select * from events where date(actual_start) = '2002-02-19'
But, it depends on how long you keep
them.
Hi,
Hopefully someone can help me. I want
to do a select statement on the events table, but for some reason when I
do a select - it will only give me todays events. If I do a query with a
begind of yesterday - I get yesterday's events.
for example:
tsm: BASSETT>select * from events
where date(actual_start)='02/19/2002' ANR2034E SELECT: No match found
using this criteria
Whereas I can do a q event * *
begind='02/19/2002'
as see this:
tsm: BASSETT>q event * *
begind='02/19/2002' Scheduled
Start Actual
Start Schedule Name Node
Name Status --------------------
-------------------- ------------- -------------
--------- 02/19/02 00:00:00 02/19/02
00:02:57 GW1-INCR
GW1
Completed 02/19/02 01:00:00 02/19/02
01:15:15 TSI-INCR
TSI
Completed 02/19/02 01:00:00 02/19/02
01:01:01 BASSETT01_IN- BASSETT01
Completed
CR 02/19/02 01:00:00 02/19/02
01:00:10 TESTAPP-INCR
TESTAPP
Completed 02/19/02 01:00:00 02/19/02
01:15:17 TRANSDB-INCR
TRANSDB
Completed 02/19/02 01:46:50 02/19/02
01:56:46 GISERVER_INCR GISERVER
Completed 02/19/02 02:00:00 02/19/02
02:08:17 TRANSIF_INCR
TRANSIF
Completed 02/19/02 02:00:00 02/19/02
02:06:27 STATGW-INCR
STATGW
Completed 02/19/02 03:00:00 02/19/02
03:07:11 UTILSRVR-INCR UTILSRVR
Completed 02/19/02 03:00:00 02/19/02
03:01:25 TSTTRANSDB-I- TSTTRANSDB
Completed
NCR 02/19/02 03:20:00 02/19/02
03:21:58 MAILHUB-INCR
MAILHUB
Completed 02/19/02 04:00:00 02/19/02
04:03:11 ORSRVR-INCR
ORSRVR
Completed 02/19/02 04:00:00 02/19/02
04:13:54 BH1-INCR
BH1
Completed 02/19/02 04:00:00 02/19/02
04:12:21 TSTTRANSIF-I- TSTTRANSIF
Completed
NCR 02/19/02 05:00:08 02/19/02
05:05:15 CWS01-INCR
CWS01
Completed 02/19/02 09:20:00 02/19/02
09:21:30 MAILHUB-INCR
MAILHUB Failed
Any suggestions? I want to use select
to do more processing - else I have to parse files.. not a problem - but a
select would be easier.
Jane
%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Jane Bamberger
IS Department
Bassett Healthcare
607-547-4784
|