3-3 최신으로

테이블 (22)

audit_boot_log

  • logid — VARCHAR
  • timestamp — DATETIME
  • status — VARCHAR
  • service — VARCHAR
  • message — TEXT

audit_conman

  • logid — INT
  • timestamp — DATETIME
  • host — VARCHAR
  • service — VARCHAR
  • processid — INT
  • level — VARCHAR
  • message — VARCHAR
  • clientip — VARCHAR

audit_cron

  • logid — INT
  • timestamp — INT
  • host — DATETIME
  • processname — VARCHAR
  • processid — VARCHAR
  • user — INT
  • command — VARCHAR

audit_dmseg

  • logid — INT
  • timestamp — DATETIME
  • kernelversion — VARCHAR
  • kernelbuild — VARCHAR
  • gccversion — VARCHAR
  • smpinfo — VARCHAR
  • fullversion — VARCHAR
  • commandline — TEXT
  • supportedcpus — VARCHAR
  • xsavefeatures — VARCHAR
  • xstateOffset — INT
  • xstateSizes — INT
  • xstateFeatures — VARCHAR
  • contextsize — INT
  • format — VARCHAR
  • mapid — INT
  • logid1 — INT
  • range — VARCHAR
  • status — VARCHAR

audit_httpd

  • logid — INT
  • timestamp — DATETIME
  • clientip — VARCHAR
  • requestmethod — VARCHAR
  • requesturl — VARCHAR
  • querystring — VARCHAR
  • protocol — VARCHAR
  • responsecode — INT
  • responsesize — INT
  • useragent — VARCHAR
  • errorlevel — VARCHAR
  • message — VARCHAR

audit_messages

  • logid — INT
  • timestamp — DATETIME
  • host — VARCHAR
  • service — VARCHAR
  • level — VARCHAR
  • message — VARCHAR

audit_ppp

  • logid — INT
  • timestamp — DATETIME
  • processname — VARCHAR
  • processid — INT
  • event — VARCHAR
  • interface — VARCHAR
  • device — VARCHAR
  • authmethod — VARCHAR
  • status — VARCHAR
  • user — VARCHAR
  • localip — VARCHAR
  • remoteip — VARCHAR

audit_rpmkgs

  • logid — INT
  • package — INT
  • package_name — VARCHAR
  • version — VARCHAR
  • architecture — VARCHAR
  • installdate — DATETIME
  • vendor — VARCHAR
  • summary — VARCHAR

audit_samba

  • logid — INT
  • timestamp — DATETIME
  • loglevel — INT
  • component — VARCHAR
  • file — VARCHAR
  • line — INT
  • server — VARCHAR
  • clientip — VARCHAR
  • service — VARCHAR
  • user — VARCHAR
  • uid — INT
  • gid — INT
  • processid — INT
  • message — VARCHAR

audit_secure

  • logid — INT
  • timestamp — DATETIME
  • host — VARCHAR(255)
  • daemon — VARCHAR(50)
  • pid — INT
  • message — TEXT
  • user — VARCHAR(100)
  • source_ip — VARCHAR(50)
  • port — INT
  • service — VARCHAR(10)
  • Result — VARCHAR(10)
  • uid — INT
  • session_status — VARCHAR(30)
  • connection_status — VARCHAR(30)

audit_spooler

  • logid — INT
  • timestamp — DATETIME
  • processname — VARCHAR
  • processid — INT
  • event — VARCHAR
  • device — VARCHAR
  • file — VARCHAR
  • remotehost — VARCHAR
  • status — VARCHAR

audit_vbox

  • logid — INT
  • timestamp — DATETIME
  • virtual_box_version — VARCHAR
  • build — VARCHAR
  • hostos — VARCHAR
  • cpu_model — VARCHAR
  • cpu_cores — TINYINT
  • vtx_enabled — BOOLEAN
  • vm_state — VARCHAR
  • guest_os — VARCHAR
  • guest_additions — VARCHAR
  • network — VARCHAR
  • final_guest_state — VARCHAR

audit_xfer_log

  • logid — INT
  • timestamp — INT
  • transferduration — INT
  • remotehost — VARCHAR
  • filesize — BIGINT
  • filename — VARCHAR
  • transfertype — CHAR
  • direction — CHAR
  • accessmode — CHAR
  • user — VARCHAR
  • servicename — VARCHAR
  • authmethod — CHAR
  • authuserid — VARCHAR
  • completionstatus — CHAR

db_api_transaction

  • transactionid — INT — 외래 키 → db_query_transaction.transactionid
  • ip_address — VARCHAR(15)
  • timestamp — DATETIME — 외래 키 → db_query_transaction.timestamp
  • http_method — VARCHAR(10)
  • request_url — VARCHAR(255)
  • http_version — VARCHAR(10)
  • status_code — INTEGER
  • response_size — INTEGER
  • referer — VARCHAR(255)
  • user_agent — VARCHAR(500)

db_query_transaction

  • transactionid — INT
  • timestamp — DATETIME — 외래 키 → user_hr_db.timestamp
  • datahash — TEXT
  • calleraddress — VARCHAR(50) — 외래 키 → user_hr_db.calleraddress
  • result — VARCHAR(20)

infra_anomaly_detection_snmp_trap

  • timestamp — INT
  • sourceIP — DATETIME
  • agent_address — VARCHAR
  • trapid — VARCHAR
  • generic_trap — INT
  • specific_trap — INT
  • varbind_list — INT
  • enterprise_oid — JSON
  • message — VARCHAR
  • snmpv3_engineid — TEXT
  • snmpv3_username — VARCHAR
  • snmpv3_securitylevel — VARCHAR
  • snmpv3_authprotocol — VARCHAR
  • snmpv3_privprotocol — VARCHAR
  • detection_name — VARCHAR
  • detection_threat_score — INT
  • ml_threshold — INT
  • mitre_tactics — VARCHAR
  • mitre_techniques — VARCHAR

infra_anomaly_detection_tcp_response

  • timestamp — INT
  • host — VARCHAR
  • daemon — INT
  • pid — INT
  • message — TIMESTAMP
  • user — TIMESTAMP
  • detection_name — VARCHAR
  • detection_threat_score — INT
  • ml_threshold — INT
  • mitre_tactics — VARCHAR
  • mitre_techniques — VARCHAR

ping_check

  • timestamp — DATETIME
  • target — VARCHAR(255)
  • ip_address — VARCHAR(45)
  • sequence — INT
  • ttl — INT
  • response_time — FLOAT
  • packet_size — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

playbook

  • rule — VARCHAR

snmp_trap

  • timestamp — VARCHAR(100) — 외래 키 → infra_anomaly_detection_snmp_trap.timestamp
  • sourceIP — DATETIME — 외래 키 → infra_anomaly_detection_snmp_trap.sourceIP
  • agentaddress — VARCHAR(255) — 외래 키 → infra_anomaly_detection_snmp_trap.agent_address
  • trapid — VARCHAR(255) — 외래 키 → infra_anomaly_detection_snmp_trap.trapid
  • generictrap — INT — 외래 키 → infra_anomaly_detection_snmp_trap.generic_trap
  • specifictrap — INT — 외래 키 → infra_anomaly_detection_snmp_trap.specific_trap
  • varbindlist — INT — 외래 키 → infra_anomaly_detection_snmp_trap.varbind_list
  • enterpriseoid — JSON — 외래 키 → infra_anomaly_detection_snmp_trap.enterprise_oid
  • message — VARCHAR(500) — 외래 키 → infra_anomaly_detection_snmp_trap.message
  • snmpv3_engineid — TEXT — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_engineid
  • snmpv3_username — VARCHAR(255) — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_username
  • snmpv3_securitylevel — VARCHAR(100) — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_securitylevel
  • snmpv3_authprotocol — VARCHAR(100) — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_authprotocol
  • snmpv3_privprotocol — VARCHAR(100) — 외래 키 → infra_anomaly_detection_snmp_trap.snmpv3_privprotocol

tcp_response

  • logid — INT
  • timestamp — DATETIME — 외래 키 → infra_anomaly_detection_tcp_response.timestamp
  • host — VARCHAR(255) — 외래 키 → infra_anomaly_detection_tcp_response.host
  • daemon — INT — 외래 키 → infra_anomaly_detection_tcp_response.daemon
  • pid — INT — 외래 키 → infra_anomaly_detection_tcp_response.pid
  • message — TIMESTAMP — 외래 키 → infra_anomaly_detection_tcp_response.message
  • user — TIMESTAMP — 외래 키 → infra_anomaly_detection_tcp_response.user

user_hr_db

  • caller — CHAR(50)
  • type_data — CHAR(300)
  • secret_key — CHAR(300)
  • calleraddress — CHAR(50)
  • user_id_real — CHAR(20)
  • user_org — CHAR(50)
  • timestamp — DATETIME
  • message — CHAR(100)