Splunk Search

How do I get total count of a field per host?

amit2312
Engager

Hi,

I am new to splunk, this might have asked and answered but didn't get the answer when i searched it. here is my query: I have a base query, which basically gets the ids field(ex : 1234,3213) from different hosts. i want to get the total number of ids per host. 

data:

host : ids: price: details

xyz:123:$45:example 

cds:143:$45:example

Labels (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

Use the stats command for that.

| stats count(ids) by host

 

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

View solution in original post

bowesmana
SplunkTrust
SplunkTrust

As @richgalloway but if you want unique ids, use dc(ids)

0 Karma

richgalloway
SplunkTrust
SplunkTrust

Use the stats command for that.

| stats count(ids) by host

 

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

amit2312
Engager

Thanks a lot for your help. it worked.

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

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...

Tech Talk | Elevating Digital Service Excellence: The Synergy of Splunk RUM & APM

Elevating Digital Service Excellence: The Synergy of Real User Monitoring and Application Performance ...