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!

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

Splunk Up Your Game: Why It's Time to Embrace Python 3.9+ and OpenSSL 3.0

Did you know that for Splunk Enterprise 9.4, Python 3.9 is the default interpreter? This shift is not just a ...