Command Palette

Search for a command to run...

Cheatsheets
PreviousNext

Security Monitoring & SIEM Fundamentals

Command / QueryDescription
event.code:4625Filter for Windows failed login attempts (Event ID 4625)
event.code:4625 AND winlog.event_data.SubStatus:0xC0000072Filter for failed login attempts against disabled accounts
event.code:4625 AND user.name: admin*Filter for failed login attempts where username starts with "admin"
event.code:4625 AND winlog.event_data.SubStatus:0xC0000072 AND @timestamp >= "2023-03-03T00:00:00.000Z" AND @timestamp <= "2023-03-06T23:59:59.999Z"Filter for failed login attempts against disabled accounts within specific time window (March 3-6, 2023)
event.code:4624Filter for successful Windows login events (Event ID 4624)
event.code:4732Filter for user additions to security-enabled local groups (Event ID 4732)
event.code:4733Filter for user removals from security-enabled local groups (Event ID 4733)
event.code:4732 OR event.code:4733Filter for both user additions and removals from local groups
(event.code:4732 OR event.code:4733) AND group.name:administratorsFilter for additions/removals to/from local Administrators group
NOT user.name: *$Exclude computer accounts (accounts ending with $) from results
NOT user.name: *$ AND winlog.channel.keyword: SecurityExclude computer accounts and filter only Windows Security channel logs
user.name: svc-*Search for all service accounts (starting with "svc-")
"svc-sql1"Free text search across all indexed fields for the string "svc-sql1"
process.name:MSBuild.exeFilter for MSBuild.exe process execution events
process.name:MSBuild.exe AND process.parent.name:(excel.exe OR winword.exe)Detect MSBuild started by Office applications (potential Living-off-the-land binary abuse)
user.name.keywordField reference - username (use .keyword for aggregations/exact match)
user.nameField reference - username (use without .keyword for wildcard searches in KQL)
host.hostname.keywordField reference - hostname of the machine generating the log
host.name.keywordField reference - name of the host
related.ip.keywordField reference - related IP addresses in the event
winlog.event_data.SubStatusField reference - Windows event substatus code (0xC0000072 = disabled account)
winlog.event_data.MemberSid.keywordField reference - Security Identifier of group member
winlog.logon.type.keywordField reference - Windows logon type
event.action.keywordField reference - action that occurred
group.name.keywordField reference - name of the group
process.name.keywordField reference - name of the process (use .keyword for aggregations)
process.nameField reference - name of the process (use without .keyword in KQL queries)
process.parent.name.keywordField reference - name of the parent process (use .keyword for aggregations)
process.parent.nameField reference - name of the parent process (use without .keyword in KQL queries)
@timestampField reference - timestamp extracted from the original event
event.createdField reference - timestamp when event was created in Elasticsearch
event.codeField reference - event code/ID (ECS standardized field)
winlog.event_idField reference - Windows event ID (Winlogbeat native field)
winlog.channel.keywordField reference - Windows event log channel (e.g., Security)