Splunk Search

How to convert hexadecimal IP to decimal

vrmandadi
Builder

Hello all,
How can we convert this to regular IP?
I tried using the below search but it's not converting correctly.
Below is the sample event:

| rex "(?i)(?<d1>[0-9A-F]{2})(?<d2>[0-9A-F]{2})(?<d3>[0-9A-F]{2})(?<d4>[0-9A-F]{2})"
 | eval ip=tostring(tonumber(d1,16))+"."+tostring(tonumber(d2,16))+"."+tostring(tonumber(d3,16))+"."+tostring(tonumber(d4,16))

SYMNP-SMI::enterprises."9.9.42.1.3.2.1.8.13.3197256382.1.1" = "0x0aa0a04b"

0 Karma
1 Solution

poete
Builder

Hello @vrmandadi,

here is the solution.

| makeresults 
| eval _raw="SYMNP-SMI::enterprises.\"9.9.42.1.3.2.1.8.13.3197256382.1.1\" = \"0x0aa0a04b\""
| rex "0x(?i)(?<d1>[0-9A-F]{2})(?<d2>[0-9A-F]{2})(?<d3>[0-9A-F]{2})(?<d4>[0-9A-F]{2})"
| eval ip=tostring(tonumber(d1,16))+"."+tostring(tonumber(d2,16))+"."+tostring(tonumber(d3,16))+"."+tostring(tonumber(d4,16))

View solution in original post

poete
Builder

Hello @vrmandadi,

here is the solution.

| makeresults 
| eval _raw="SYMNP-SMI::enterprises.\"9.9.42.1.3.2.1.8.13.3197256382.1.1\" = \"0x0aa0a04b\""
| rex "0x(?i)(?<d1>[0-9A-F]{2})(?<d2>[0-9A-F]{2})(?<d3>[0-9A-F]{2})(?<d4>[0-9A-F]{2})"
| eval ip=tostring(tonumber(d1,16))+"."+tostring(tonumber(d2,16))+"."+tostring(tonumber(d3,16))+"."+tostring(tonumber(d4,16))

vrmandadi
Builder

Thank you very much @poete

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...