Claroty - Multiple failed logins by user

Back


Id	4b5bb3fc-c690-4f54-9a74-016213d699b4
Rulename	Claroty - Multiple failed logins by user
Description	Detects multiple failed logins by same user.
Severity	High
Tactics	InitialAccess
Techniques	T1190 T1133
Required data connectors	CefAma
Kind	Scheduled
Query frequency	1h
Query period	1h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Claroty/Analytic Rules/ClarotyMultipleFailedLogin.yaml
Version	1.0.3
Arm template	4b5bb3fc-c690-4f54-9a74-016213d699b4.json

KQL

let threshold = 5;
ClarotyEvent
| where EventType has 'Login to SRA'
| where EventType !has 'succeeded'
| extend SrcUsername = extract(@'User\s(.*?)\sfailed', 1, EventMessage)
| summarize count() by SrcUsername, bin(TimeGenerated, 5m)
| where count_ > threshold
| extend AccountCustomEntity = SrcUsername

YAML

queryFrequency: 1h
queryPeriod: 1h
id: 4b5bb3fc-c690-4f54-9a74-016213d699b4
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Claroty/Analytic Rules/ClarotyMultipleFailedLogin.yaml
tactics:
- InitialAccess
version: 1.0.3
severity: High
description: |
    'Detects multiple failed logins by same user.'
entityMappings:
- fieldMappings:
  - columnName: AccountCustomEntity
    identifier: Name
  entityType: Account
query: |
  let threshold = 5;
  ClarotyEvent
  | where EventType has 'Login to SRA'
  | where EventType !has 'succeeded'
  | extend SrcUsername = extract(@'User\s(.*?)\sfailed', 1, EventMessage)
  | summarize count() by SrcUsername, bin(TimeGenerated, 5m)
  | where count_ > threshold
  | extend AccountCustomEntity = SrcUsername  
triggerThreshold: 0
kind: Scheduled
triggerOperator: gt
relevantTechniques:
- T1190
- T1133
name: Claroty - Multiple failed logins by user
requiredDataConnectors:
- dataTypes:
  - CommonSecurityLog
  connectorId: CefAma
status: Available

ARM