Splunk Search

tonumber Not Working?

andrewkenth
Communicator

I have windows logs and I have extracted the Process ID's and Login ID's. I thought the | eval tonumber would work but it doesn't return anything.

In this example my Login Id is 0x29019c75

index=charlesriver sourcetype="windows_events" WindowsLogonID=0x29019c75 | eval WindowsLoginID=tonumber(WindowsLoginID) | table _time ADLogon WindowsLoginID | sort -WindowsLoginID

(In case you are asking why, we are comparing the login id to what is logged in an application log)

Tags (1)
0 Karma

somesoni2
Revered Legend

The WindowsLoginID field is represented in Hex format so use following. (see tonumber)

index=charlesriver sourcetype="windows_events"   WindowsLogonID=0x29019c75 | eval WindowsLoginID=tonumber(WindowsLoginID,16)  | table  _time ADLogon WindowsLoginID  | sort  -WindowsLoginID
0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In January, the Splunk Threat Research Team had one release of new security content via the Splunk ES Content ...

Expert Tips from Splunk Professional Services, Ensuring Compliance, and More New ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Observability Release Update: AI Assistant, AppD + Observability Cloud Integrations & ...

This month’s releases across the Splunk Observability portfolio deliver earlier detection and faster ...