Splunk Enterprise Security

need spl into datamodel search

AL3Z
Builder

Hi,
Need below search into a web datmodel search 
index=es_web action=blocked host= * sourcetype= *
| stats count by category
| sort 5 -count

thanks

Labels (1)
0 Karma

fredclown
Builder

I think this should work. You shouldn't need to include the host=* or sourcetype=* as every event has a host and sourcetype.

|tstats count from datamodel={your data model} where index="es_web" AND {your data model}.action="blocked" by {your data model}.category
|sort 5 -count
Get Updates on the Splunk Community!

Wrapping Up Cybersecurity Awareness Month

October might be wrapping up, but for Splunk Education, cybersecurity awareness never goes out of season. ...

🌟 From Audit Chaos to Clarity: Welcoming Audit Trail v2

🗣 You Spoke, We Listened  Audit Trail v2 wasn’t written in isolation—it was shaped by your voices.  In ...

What's New in Splunk Observability - October 2025

What’s New?    We’re excited to announce the latest enhancements to Splunk Observability Cloud and share ...