/
sqlite in junos SQLite format 3

sqlite in junos SQLite format 3


https://www.juniper.net/documentation/en_US/junos/topics/reference/command-summary/show-security-log-query.html


log streamShow security logs stream info

show security log stream file report_utm0

log stream
jcluser@SDK-vSRX_ContentFilter> show security log stream file ?              
Possible completions:
  <file-name>          Name of the stream log file to be displayed 
  alert/               Last changed: Apr 01 2020
  conf/                Last changed: Apr 01 2020
  llmd_db0             Size: 4096, Last changed: Jun 10 2019
  llmd_db0-shm         Size: 32768, Last changed: Nov 05 07:15:05
  llmd_db0-wal         Size: 16512, Last changed: Jun 10 2019
  llmd_db1             Size: 4096, Last changed: Jun 10 2019
  llmd_db1-shm         Size: 32768, Last changed: Nov 05 07:15:05
  llmd_db1-wal         Size: 16512, Last changed: Jun 10 2019
  logical-system       Logical-system name
  logical-systems/     Last changed: Jun 10 2019
  report_idp0          Size: 4096, Last changed: Jun 10 2019
  report_idp0-shm      Size: 32768, Last changed: Nov 05 07:15:05
  report_idp0-wal      Size: 61832, Last changed: Apr 01 2020
  report_idp1          Size: 4096, Last changed: Jun 10 2019
  report_idp1-shm      Size: 32768, Last changed: Nov 05 07:15


log queryQuery logs from database

log query
jcluser@SDK-vSRX_ContentFilter> show security log query ?                      
Possible completions:
  application          Filter application
  category             Category name
  count                Number of logs to be queried
  dst-ip               Filter destination ip
  dst-port             Filter destination port (1..65535)
  event-type           Filter event-type
  service              Filter service
  src-ip               Filter source ip
  src-port             Filter source port (1..65535)
  start-time           Earliest timestamp to include in output (YYYY-MM-DDTHH:MM:SS)
  stop-time            Latest timestamp to include in output (YYYY-MM-DDTHH:MM:SS)
  user                 Filter user

category
juniper@SDK-vSRX_JCL_EWF> show security log query category utm ?
Possible completions:
  <[Enter]>            Execute this command
  application          Filter application
  count                Number of logs to be queried
  dst-ip               Filter destination ip
  dst-port             Filter destination port (1..65535)
  event-type           Filter event-type
  service              Filter service
  src-ip               Filter source ip
  src-port             Filter source port (1..65535)
  start-time           Earliest timestamp to include in output (YYYY-MM-DDTHH:MM:SS)
  stop-time            Latest timestamp to include in output (YYYY-MM-DDTHH:MM:SS)
  user                 Filter user
  |                    Pipe through a command

Related content

syslog and security log format
syslog and security log format
More like this
syslog filter
syslog filter
More like this
script for the creation of ANR report
script for the creation of ANR report
More like this
junos data model
junos data model
More like this
SIEM Syslog, LEEF and CEF Logging
SIEM Syslog, LEEF and CEF Logging
More like this
syslog and security Transport encryption
syslog and security Transport encryption
More like this