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 Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...