I am using KIWI to view the syslog of a Meraki MX84 security Appliance.
The output of the log file is difficult to read, as all the necessary information is in the message box, and it is just one long message.
3/21/2018 6:18 | Local0.Info | 10.0.2.25 | 1 1521627538.568617081 Shelton_Town_Hall_Firewall urls src=192.168.10.227:51564 dst=204.79.197.200:443 mac=58:F3:9C:8D:38:07 request: UNKNOWN https://www.bing.com/... |
Is there any way to break down the message line, or at least extract the SRC=x.x.x.x from it, and when I view it in excel, have the SRC be it's own column, so that I can view and sort easier?
Any help that anyone can offer would be greatly appreciated!!!
Thank you