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!

Take the 2021 Splunk Career Survey for $50 in Amazon Cash

Help us learn about how Splunk has impacted your career by taking the 2021 Splunk Career Survey. Last year’s ...

Using Machine Learning for Hunting Security Threats

WATCH NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more for ...

Observability Newsletter Highlights | March 2023

 March 2023 | Check out the latest and greatestSplunk APM's New Tag Filter ExperienceSplunk APM has updated ...