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
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...