Splunk Search

URLDECODE

erlindemberg
Explorer

I would like to know how can I use the urldecorder command for all URLs in the reqHdr.referer field (Akamai)

index=akamai
| eval newfield = urldecode("https%3a%2f%2fwww....................%2f")
| table newfield

0 Karma
1 Solution

jkat54
SplunkTrust
SplunkTrust
 ... | eval newField=urldecode('reqHdr.referer') | table newField

View solution in original post

jkat54
SplunkTrust
SplunkTrust
 ... | eval newField=urldecode('reqHdr.referer') | table newField

erlindemberg
Explorer

I've tried and the field doesn't show the URLs, just the name reqHdr.referer

0 Karma

jkat54
SplunkTrust
SplunkTrust

Tried it with single quotes around it?

0 Karma

snallam123
Path Finder

index=c4_akamai
| eval newfield = urldecode('reqHdr.referer')
| table newfield

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Don't use double quotes "around the field name. Try without quotes. If that doesn't work, use single quotes '.

---
If this reply helps you, Karma would be appreciated.

erlindemberg
Explorer

Thanks for the help, with single quotes it worked.

0 Karma

erlindemberg
Explorer

Using this query:

index=c4_akamai
| eval newfield = urldecode("reqHdr.referer")
| table newfield

o resultado é:

newfield
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer

Eu usando apenas uma URL de referencia dentro do campo reqHdr.referer o resultado é:

index=c4_akamai
| eval newfield = urldecode("https%3a%2f%2fwww.*******.com.br%2f")
| table newfield

newfield
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/

0 Karma

richgalloway
SplunkTrust
SplunkTrust

What results do you get and what results do you expect?

---
If this reply helps you, Karma would be appreciated.
0 Karma

erlindemberg
Explorer

Using this query:

index=c4_akamai
| eval newfield = urldecode("reqHdr.referer")
| table newfield

o resultado é:

newfield
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer
reqHdr.referer

Eu usando apenas uma URL de referencia dentro do campo reqHdr.referer o resultado é:

index=c4_akamai
| eval newfield = urldecode("https%3a%2f%2fwww.*******.com.br%2f")
| table newfield

newfield
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/
https://www.**********.com.br/

0 Karma

erlindemberg
Explorer

In this case, if I specify a single URL in this field it will bring me the result of the decoded URL.
However, the field has thousands of other URLs.

The result I hope is that all URLs are shown decrypted.

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Can you share some sample data?

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

The OpenTelemetry Certified Associate (OTCA) Exam

What’s this OTCA exam? The Linux Foundation offers the OpenTelemetry Certified Associate (OTCA) credential to ...

From Manual to Agentic: Level Up Your SOC at Cisco Live

Welcome to the Era of the Agentic SOC   Are you tired of being a manual alert responder? The security ...

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...