Splunk Search

Can I generate a table in which I list every event with the four variables?


Hey Guys, I have the following data in Splunk. Each eventdata has 4 lines (which are seperated through newLines) and every line in a event represent the value of a variable. 

My Question: Can I generate a table in which I list every event with the four variables. The table I wont to have should look like the following excel table :




Thanks for your help!

Labels (1)
0 Karma

Esteemed Legend

Hi @leon12,

I suppose that the Datum is also the timestamp of the event.

In this case, please try something like this:

|  rex "(?ms).*Description:\s(?<Description>.*).*Node:\s+(?<Node>.*).*Severity:\s+(?<Severity>.*)"
| table _time Description Node Severity

That you can test at https://regex101.com/r/tCns4x/1

If Datum isn't also the timestamp, you have two ways:

  • modify your props.conf to use Datum as timestamp (_time),
  • insert datum in the regex

I hint the first solution.



0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Updates (ESCU) - New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 3 releases of new content via the Enterprise ...

Thought Leaders are Validating Your Hard Work and Training Rigor

As a Splunk enthusiast and member of the Splunk Community, you are one of thousands who recognize the value of ...

.conf23 Registration is Now Open!

Time to toss the .conf-etti &#x1f389; —  .conf23 registration is open!   Join us in Las Vegas July 17-20 for ...