topic Re: need help on rex in Splunk Enterprise

need help on rex

Ash1 — Fri, 11 Aug 2023 21:04:08 GMT

From the below sample logs we need rex for

1. "appl has successfully completed all authentication flows."

2. "Login complete"

2023-01-11 12:34:22,678 DITAU [taskstatus-8] {DIM: hgtijNMHy67v | DIS: aHJyikjI | DIC: HY56GFT6 | PI: 678.89.987 | ND: ks | APP: |OS: iOS-1-7.1 | REV" } APPDA - 87687654356789 - appl has successfully completed all authentication flows.

2023-01-11 12:34:22,678 INFO [taskstatus-8] {DIM: hgtijNMHy67v | DIS: aHJyikjI | DIC: HY56GFT6 | PI: 678.89.987 | ND: ks | APP: | Req: POST /ai/v2/api/assert | OS: iOS-16.6 | VER: 23.4.0} AUDIT - Login complete

Re: need help on rex

richgalloway — Sat, 12 Aug 2023 00:11:29 GMT

The rex command is for extracting fields using regular expressions. What fields do you need to extract from those events?

If you just need to find events with either of those strings then you don't need rex at all. Just put the strings in your base search.

index=foo ( "appl has successfully completed all authentication flows." OR "Login complete" )

Re: need help on rex

Ash1 — Sat, 12 Aug 2023 01:03:07 GMT

Hi @richgalloway , I need to do field extra action for those 2 strings which i mentioned.

That's why I asked for rex

Field 1: appl has successfully completed all authentication flows (field name as success_logins)

Field2: Login complete" (field name as complete_logins)

Re: need help on rex

ITWhisperer — Sat, 12 Aug 2023 06:51:48 GMT

| rex "(?<success_logins>appl has successfully completed all authentication flows.)" | rex "(?<complete_logins>Login complete)"