Splunk Search

IP address of current user?

matstap
Communicator

I'm trying to write a query to display the IP address of the current user. Anyone know how to do this?

0 Karma
1 Solution

elliotproebstel
Champion

Depending on your infrastructure, the following may work:

index=_internal sourcetype=splunkd_ui_access 
    [| rest /services/authentication/current-context splunk_server=local 
    | stats values(username) AS search 
    | format ] 
| head 1 
| stats list(clientip) AS clientip

The subsearch will return the username of the user who is currently logged in. It uses that to search across splunkd_ui_access logs and extracts the clientip from the latest matching one.

However, this doesn't work at all on my system, because we have a proxy on our Splunk server, which means this returns 127.0.0.1 for every user. 🙂 So your mileage may vary.

View solution in original post

elliotproebstel
Champion

Depending on your infrastructure, the following may work:

index=_internal sourcetype=splunkd_ui_access 
    [| rest /services/authentication/current-context splunk_server=local 
    | stats values(username) AS search 
    | format ] 
| head 1 
| stats list(clientip) AS clientip

The subsearch will return the username of the user who is currently logged in. It uses that to search across splunkd_ui_access logs and extracts the clientip from the latest matching one.

However, this doesn't work at all on my system, because we have a proxy on our Splunk server, which means this returns 127.0.0.1 for every user. 🙂 So your mileage may vary.

skoelpin
SplunkTrust
SplunkTrust

We're going to need more information than that..

Are your events logging in Splunk? Did you have a field that captures the IP addresses? Do you have a field or lookup table of users? You want the current users IP address who's logged into Splunk? And lastly, ofcourse we know how to do this.. You provide the correct information and we provide the correct solution 🙂

0 Karma

somesoni2
Revered Legend

Current user using Splunk Web UI (trying to display from user logged in from)?

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

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