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

name: Claroty - Multiple failed logins by user
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  
queryFrequency: 1h
triggerOperator: gt
requiredDataConnectors:
- dataTypes:
  - CommonSecurityLog
  connectorId: CefAma
status: Available
entityMappings:
- entityType: Account
  fieldMappings:
  - identifier: Name
    columnName: AccountCustomEntity
triggerThreshold: 0
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Claroty/Analytic Rules/ClarotyMultipleFailedLogin.yaml
description: |
    'Detects multiple failed logins by same user.'
version: 1.0.3
id: 4b5bb3fc-c690-4f54-9a74-016213d699b4
kind: Scheduled
relevantTechniques:
- T1190
- T1133
severity: High
tactics:
- InitialAccess
queryPeriod: 1h

ARM