Knowledge Management

Calculated field

VijaySrrie
Builder

Hi Team,

I have a field extraction  and a calculated field which is not working
Please let me know whether there is any other way to extract it

EXTRACT-User = \"path\"\:\"auth\/(abc|xyz)\/login\/(?<User>[\w\_]+)
EVAL-user = if(error="invalid credentials",User,'auth.display_name')



"auth.display_name" is the existing field

Labels (2)
0 Karma

antoniolamonica
Explorer

Before you do your eval statement, test that your extraction works.
In your query, use a rex statement to see test this.

...
| rex field=<your_field> "\"path\"\:\"auth\/(abc|xyz)\/login\/(?<User>[\w\_]+)"
...


Then once you confirm you extracting your User field values, add the eval statement in the query.
Once you confirm that works, you can then go back to your sourcetype, and modify your extract and eval lines. 
---
If this reply helps you, Karma would be appreciated.

Tags (3)
0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...

Edge Processor Scaling, Energy & Manufacturing Use Cases, and More New Articles on ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Get More Out of Your Security Practice With a SIEM

Get More Out of Your Security Practice With a SIEMWednesday, July 31, 2024  |  11AM PT / 2PM ETREGISTER ...