Install Guide
For HIWARE PSM VIEW configuration, please contact Logpresso or NetAnd customer support for assistance.
HIWARE PSM Login VIEW
- Logger Model: HIWARE Login
- Table: SAC_HIWARE_LOGIN
- SQL: select * from VW_USER_LOGIN_HIST $where order by USER_LOGIN_DTTM limit 10000
- Condition Clause: where USER_LOGIN_DTTM > ?
- Primary Reference Column: USER_LOGIN_DTTM
HIWARE PSM Login Failure VIEW
- Logger Model:
HIWARE Login Failure - Table: SAC_HIWARE_LOGIN_FAIL
- SQL: select * from VW_USER_LOGIN_FAIL_HIST $where order by LOGIN_CONN_DTTM limit 10000
- Condition Clause: where LOGIN_CONN_DTTM > ?
- Primary Reference Column: LOGIN_CONN_DTTM
HIWARE PSM Session VIEW
- Logger Model:
HIWARE Session - Table:
SAC_HIWARE_SESSION - SQL: select * from VW_EQMT_CONN_HIST $where order by EQMT_LOGIN_DTTM limit 10000
- Condition Clause: where EQMT_LOGIN_DTTM > ?
- Primary Reference Column: EQMT_LOGIN_DTTM
HIWARE PSM Denied Session VIEW
- Logger Model:
HIWARE Denied Session - Table:
SAC_HIWARE_BAN_SESSION - SQL:
select * from VW_EQMT_CONN_ILLEGAL_HIST $where order by EQMT_LOGIN_DTTM limit 10000 - Condition Clause: where EQMT_LOGIN_DTTM > ?
- Primary Reference Column:
EQMT_LOGIN_DTTM
HIWARE PSM Command Audit VIEW
- Logger Model:
HIWARE Command Audit - Table:
SAC_HIWARE_CMD - SQL:
select * from VW_CMD_USE_HIST $where order by CMD_INPUT_DTTM limit 10000 - Condition Clause: where CMD_INPUT_DTTM > ?
- Primary Reference Column:
CMD_INPUT_DTTM
HIWARE PSM Block Response VIEW
- Logger Model:
HIWARE Block Response - Table:
SAC_HIWARE_RESPONSE - SQL:
select * from VW_SESS_SHUT_HIST $where order by EQMT_SESS_SHUT_START_DTTM limit 10000 - Condition Clause: where EQMT_SESS_SHUT_START_DTTM > ?
- Primary Reference Column:
EQMT_SESS_SHUT_START_DTTM
HIWARE PSM Account Management VIEW
- Logger Model:
HIWARE Account Management - Table:
SAC_HIWARE_USER_MGMT - SQL:
select * from VW_USER_DEL_HIST $where order by DEL_DTTM limit 10000 - Condition Clause: where DEL_DTTM > ?
- Primary Reference Column:
DEL_DTTM