Skip to content
CyberSimStart training

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

Part of