Splunk Search

How do I extract this field from my sample data?

splgeek
Explorer

I want to extract the PHP Message as a field so I can have all the various php error messages:

2016/10/20 21:23:18 [error] 26550#26550: *9254611 FastCGI sent in stderr: "PHP message: PHP Warning:  trim() expects parameter 1 to be string, array given in /var/www/html/xx/xxxx-xx.xxxx.xxx.com/wordpress/wp-includes/option.php on line 247" while reading response header from upstream, client: 0.0.0.00, server: _, request: "GET / HTTP/1.1", upstream: "fastcgi://000.0.0.1:9000", host: "xxx.xx.com"
0 Karma
1 Solution

somesoni2
Revered Legend

Give this a try

your base search | rex "PHP message\: (?<PHPError>[^\"]+)"

View solution in original post

0 Karma

somesoni2
Revered Legend

Give this a try

your base search | rex "PHP message\: (?<PHPError>[^\"]+)"
0 Karma

splgeek
Explorer

thanks
that did work
so this could not have been possible with the IFX right?

0 Karma

somesoni2
Revered Legend

I think it would. Be sure to select the whole string that you want to extract OR you can specify your own regex (this one) in the IFX to save it.

0 Karma
Get Updates on the Splunk Community!

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...

Updated Team Landing Page in Splunk Observability

We’re making some changes to the team landing page in Splunk Observability, based on your feedback. The ...

New! Splunk Observability Search Enhancements for Splunk APM Services/Traces and ...

Regardless of where you are in Splunk Observability, you can search for relevant APM targets including service ...