File: tag-ssh-msgs.lnav

package info (click to toggle)
lnav 0.12.4-1
  • links: PTS, VCS
  • area: main
  • in suites: forky, trixie
  • size: 45,628 kB
  • sloc: cpp: 199,328; ansic: 57,269; sh: 4,509; makefile: 3,387; python: 980; sql: 280; xml: 264; javascript: 18
file content (10 lines) | stat: -rw-r--r-- 255 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
 
#
# @synopsis: tag-ssh-msgs
# @description: Tag interesting SSH log messages
#

;UPDATE all_logs
     SET log_tags = json_concat(log_tags, '#ssh.invalid-user')
     WHERE log_text LIKE '%Invalid user from%'

;SELECT 'Tagged ' || changes() || ' messages';