Splunk Search

Unable to get data on statistics using stats

vplunk
Explorer

Hi , 

I am trying to run a splunk query and i am able to generate the required filed . however i am facing difficulties in replicating the same using stats under statistics table 

For example , 

Under selected filed , I was able to retrieve the required fields , lets say User, host, IP, LP and session 

When i use the below command 

stats values(User) AS user , values(host) AS host, values(LP) AS LP, values(IP) AS IP BY session

Session is common and appears for all.

But i am able to see only host , session , LP values under statistics but user and IP values are not being displayed although they are available under the selected field. ( when you look into events tab)

Any help would be appreciated !!

Labels (1)
0 Karma
Get Updates on the Splunk Community!

Index This | Why did the turkey cross the road?

November 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

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 ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...