How extract field using rex?

karthi2809 — Thu, 06 Apr 2023 05:03:13 GMT

How to extract fields in between | servername |

Which i am using in rex

^[^\|\n]*\|(?P<Server>\w+\.\w+\.\w+\.\w+\s+)

But its not extracting the all the servers

05-Apr-2023 04:42:44:PM: |IISN11WCRL02.nnp.anp.co.xx | Ping statistics for 10.10.10.194: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 54ms, Maximum = 54ms, Average = 54ms
4/5/23
4:42:41.000 AM
05-Apr-2023 04:42:41:PM: |IISN11WCRL02.nnp.anp.co.xx | Ping statistics for 10.10.10.194: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 54ms, Maximum = 57ms, Average = 54ms
4/5/23
4:42:38.000 AM
05-Apr-2023 04:42:38:PM: |IIISN11WCRL02.nnp.anp.co.xx | Ping statistics for 10.10.10.194: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 53ms, Maximum = 54ms, Average = 53ms
4/5/23
4:42:34.000 AM
05-Apr-2023 04:42:34:PM: |naz11sry001l | Ping statistics for 10.10.10.194: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 53ms, Maximum = 55ms, Average = 54ms
4/5/23
4:42:31.000 AM
05-Apr-2023 04:42:31:PM: |naz11sry002l | Ping statistics for 10.10.10.194: Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds: Minimum = 53ms, Maximum = 55ms, Average = 54ms

Re: How extract field using rex?

ITWhisperer — Thu, 06 Apr 2023 05:15:36 GMT

Try this

| rex "^[^\|\n]*\|(?P<Server>[^\|]+)"

Re: How extract field using rex?

Gr0und_Z3r0 — Thu, 06 Apr 2023 06:39:48 GMT

@karthi2809 you can try something like this....

| rex field=_raw "\|(?P<Server>[\w\.]+)\s\|"

~ If the reply helps an upvote would be appreciated.

topic Re: How extract field using rex? in Splunk Search

How extract field using rex?

Re: How extract field using rex?

Re: How extract field using rex?