Dashboards & Visualizations

Syslog failed event to be viewed in a table format?

SanjeewaF3
New Member

Hi all,

Just like to know how to convert this syslog log event to be viewed as a table format in Splunk? Guessing this needs be in a rex format similar to another splunk answer post that i saw but i am newbie in this area.

EG Syslog:
Oct 3 18:57:37 abc001234 sshd[12345678]: Failed password for invalid user usr123d from 11.22.33.44 port 66778 ssh2

So the table would be something like this
Date/time
Server (abc001234)
User (usr123d)
IP (11.22.33.44)
Port (66778)

Greatly appreciate your help in this! Thanks.

Tags (1)
0 Karma

mydog8it
Builder

Start with extracting the interesting fields, here is a link to some info:
http://docs.splunk.com/Splexicon:Fieldextraction

Then try a search something like:
Index=* sourcetype=syslog Failed | table _time Server User IP Port

Here is a link to some educaton videos as well: https://www.splunk.com/view/education-videos/SP-CAAAGB6
Try searching Youtube for some beginner videos also.

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...