Splunk Search

How to rename a field in splunk?

okinyx
New Member

I am trying to rename a filed in splunk and it does not work. This is for my lab and below is the command string

index=main sourcetype=access_combined_wcookie action=purchase status=200 file="success.do"  JSESSIONID="*" | rename JESESSIONID as "UserSessions"
Tags (2)
0 Karma
1 Solution

niketn
Legend

Because there is a spelling mistake in fieldname JSESSIONID which is misspelled as JESESSIONID inside the rename command. Please try the following:

index=main sourcetype=access_combined_wcookie action=purchase status=200 file="success.do" JSESSIONID="*" 
| rename JSESSIONID as UserSessions

PS: Your base search has correct fieldname.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

View solution in original post

niketn
Legend

Because there is a spelling mistake in fieldname JSESSIONID which is misspelled as JESESSIONID inside the rename command. Please try the following:

index=main sourcetype=access_combined_wcookie action=purchase status=200 file="success.do" JSESSIONID="*" 
| rename JSESSIONID as UserSessions

PS: Your base search has correct fieldname.

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"

okinyx
New Member

Thank you very much. That worked

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...