Theory · 8 min · SIEM, EDR, SOAR and your first queries
The same hunt in SPL
Translate a simple hunt between KQL and Splunk’s SPL.
Splunk’s Search Processing Language starts with a search over indexed events: index and sourcetype narrow where to look, and field=value pairs filter. Commands follow after a pipe, like KQL.
stats count by field groups and counts, like KQL’s summarize. sort -field sorts descending. table chooses columns, like project. The time range is usually set with earliest= or the time picker.
Field names depend on how the data was onboarded. With the Splunk Add-on for Windows, failed logons are EventCode=4625 in the Security log. Always check the field names in your own environment.
Your turn: build a query clause by clause. Build a Splunk search: failed Windows logons in the last 24 hours, counted per source address, highest first.
Do the interactive check Free, in the browser.
Sources
- Splunk Search Tutorial: about the search language Splunk
- Splunk Search Reference: stats Splunk
- 4625(F): An account failed to log on Microsoft Learn