Tim, did you attach a aleabanr.gif and leavesBkgrd.jpg on purpose. Because this is
the second time someone has sent these apparently useless attachments to me. Possible
virus???
>>> [EMAIL PROTECTED] 02/21 3:56 PM >>>
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
-----Original Message-----
From: Jane Bamberger [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 21, 2002 8:17 AM
To: [EMAIL PROTECTED]
Subject: Re: select staetment
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
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Seay, Paul
Sent: Wednesday, February 20, 2002 8:34 PM
To: [EMAIL PROTECTED]
Subject: Re: select staetment
select * from events where date(actual_start) = '2002-02-19'
But, it depends on how long you keep them.
-----Original Message-----
From: Jane Bamberger [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 4:26 PM
To: [EMAIL PROTECTED]
Subject: select staetment
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
