Splunk Search

Count Issues

garrettpelak5
New Member

I'm trying to count all my data by each day of the week each time a host is hit.
EX: machine a has a script run once Monday, and Tuesday and three times on Wednesday. I just wanna track how many times a week it's hit per week. I know I can bucket _time but can't get the count function to properly display the info.

index=x sourcetype=x host=*
| bucket _time span=day
| count by host by day

Any help would be much appreciated

0 Karma

adonio
Ultra Champion

try use the stats command, understand the attributes and the by clause. and also work on your arguments of the bin / bucket commands
read here:
https://docs.splunk.com/Documentation/Splunk/7.2.6/SearchReference/Bin

index=x sourcetype=x host=*
| bucket _time span=1day
| stats count by host _time

hope it helps

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...

Move CrowdStrike FDR ingestion to Data Inputs with a guided migration

CrowdStrike Falcon Data Replicator data is essential for security investigations, detections, and response. It ...

Make Your Machine Data AI-Ready in Splunk

Every team is getting ready for AI agents.    Watch On-Demand   In this Tech Talk, Splunk platform specialists ...