XMA: What is the datetime format in REPSAMP?

XMA: What is the datetime format in REPSAMP?

REPSAMP is the report sample file in the XMA installation subvolume. 

Datetime format in the REPSAMP is MM-DD :HH . Replace 99-99:99 with the time frame you require.

For example, the query below will retrieve records between 8.00pm 2018/05/25 and 8.00pm 2018/05/26.

?section failure_report
set list_count 0;
set layout left_margin 05;
set layout right_margin 128;
-- Select Rows --
select
        xma_auditdetailtbl.recordgmt,
        xma_auditdetailtbl.recordlct,
        xma_auditdetailtbl.outcome,
        xma_auditdetailtbl.alerted,
        xma_auditdetailtbl.productcode,
        xma_auditdetailtbl.subject_usernumber_major,
        xma_auditdetailtbl.subject_usernumber_minor,
        xma_auditdetailtbl.target_usernumber_major,
        xma_auditdetailtbl.target_usernumber_minor,
        xma_auditdetailtbl.subjectlogin,
        xma_auditdetailtbl.subjectsystem,
        xma_auditdetailtbl.targetlogin,
        xma_auditdetailtbl.objectname,
        xma_auditdetailtbl.messagecode,
        xma_auditdetailtbl.result ,
        xma_audsessiontbl.sessionid
from =xma_auditdetailtbl,
     =xma_audsessiontbl
where
      (xma_audsessiontbl.recordsessionkey
            = xma_auditdetailtbl.recordsessionkey)
      and
-- *** Start Change Dates Here ***
      (xma_auditdetailtbl.recordlct > extend (datetime "05-25:20"
                  month to hour,year to fraction)
        and
        xma_auditdetailtbl.recordlct < extend (datetime "05-26:20" month to
-- *** End Change Dates Here ***
         hour, year to fraction))
        and xma_auditdetailtbl.outcome = "3"
-- ** sort order
  order by xma_auditdetailtbl.recordlct
;

If this article did not provide a solution, please open a case with our support team by sending an email message to support@xypro.com.

    • Related Articles

    • Is there an RFC standard format for XMA syslog messages?

      XYGATEMA does not follow a RFC standard format for delivering syslog messages. XMA builds the messages based on the ALERTSTRING configuration for each filter that is added to the FILTERS. The FILTERS file is located in the XYGATEMA installation ...

    • XAC: An ASSIGN command is required to use XAC REPSAMP file

      To execute ENFORM with the REPSAMP file without File Error #11, the logical record name must be assigned to an actual file name. As shown in the example below, the ASSIGN command should be executed before running ENFORM at TACL: < An ASSIGN example ...

    • XMA:An example of XMA FILTER that supports IEFT format messages

      ACTION_BEGIN ACTIONTYPE SYSLOGQ IPALERT_MSGDELIMITER CR IPALERT_IPPROCESS $ZTC0 IPALERT_ADDRESS 10.12.34.56 IPALERT_PORT 7890 !== !== ALERTSTRINGs for IEFT format : HEADER + (nil) + MSG !== !== ALERTSTRINGs for HEADER ALERTSTRING <1> VERSION ...

    • XMA: ALERTSTRING SUBSTR can be used to separate date and time from the DateTime string

      SUBSTR syntax: |(SUBSTR(<table>.<column name>,<start>,<length>))| <table>: either of the following; - AUDIT: represents the AUDDET table - SESSION: represents the AUDSESS table - INSTALL: represents the AUDINST table <column name>: a column name of ...

    • XMA: how to resize DETSEIND

      To resize DETSEIND, Turn on the screen capture. XMA_PWSTOP (stop XMA) XMA_LOAD_DEFINES In SQLCI, DROP INDEX =XMA_DETSEIND; CREATE INDEX =XMA_DETSEIND ON =XMA_AUDITDETAILTBL ( RECORDSESSIONKEY ) CATALOG =XMA_CAT EXTENT (<extent>,<extent>) format 2 ...