The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Parser for syslog.

My customer wants to ingest syslog data into Vertica. Does someone have any practical method or example?

==Sample of the syslog==
Jan 12 00:00:02 111.222.123.186 111.222.123.186 TMNX: 114232 vprn40000 SYSTEM-WARNING-tmnxStateChange-2012 [IPSEC]: Status of IPsec tunnel TUNNEL_01113234_OPS_OPS changed administrative state: inService, operational state: outOfService
Jan 12 00:00:08 192.168.1.144 192.168.1.33 TMNX: 213321 Base VRTR-MINOR-tmnxVRtrBfdSessExtDown-2022 [192.168.2.12]: BFD: Local Discriminator 522 333FD session on node 192.168.1.12 is down due to noHeartBeat
Jan 12 00:00:09 192.168.1.43 192.168.1.5 TMNX: 22232 Base VRRP-MINOR-vrrpTrapNewMaster-2011 [Becoming Master]: VRRP virtual router instance 1 on interface TenGigabitEthernet 2/2/1.221 (primary address 192.168.1.33) changed state to master

Thanks in advance,

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.