[no subject]

MessageI 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:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Seay, Paul
  Sent: Wednesday, February 20, 2002 8:34 PM
  To: ADSM-L AT VM.MARIST DOT EDU
  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:jane.bamberger AT BASSETT DOT ORG]
    Sent: Wednesday, February 20, 2002 4:26 PM
    To: ADSM-L AT VM.MARIST DOT EDU
    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
    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