Claroty - Multiple failed logins to same destinations

Back


Id	1c2310ef-19bf-4caf-b2b0-a4c983932fa5
Rulename	Claroty - Multiple failed logins to same destinations
Description	Detects multiple failed logins to same destinations.
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/ClarotyMultipleFailedLoginsSameDst.yaml
Version	1.0.3
Arm template	1c2310ef-19bf-4caf-b2b0-a4c983932fa5.json

KQL

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

YAML

kind: Scheduled
requiredDataConnectors:
- connectorId: CefAma
  dataTypes:
  - CommonSecurityLog
queryPeriod: 1h
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Claroty/Analytic Rules/ClarotyMultipleFailedLoginsSameDst.yaml
entityMappings:
- entityType: SecurityGroup
  fieldMappings:
  - columnName: SGCustomEntity
    identifier: DistinguishedName
severity: High
version: 1.0.3
name: Claroty - Multiple failed logins to same destinations
relevantTechniques:
- T1190
- T1133
tactics:
- InitialAccess
triggerOperator: gt
id: 1c2310ef-19bf-4caf-b2b0-a4c983932fa5
query: |
  let threshold = 10;
  ClarotyEvent
  | where EventType has 'Login to SRA'
  | where EventType !has 'succeeded'
  | extend Site = column_ifexists("site_name","")
  | where isnotempty(Site)
  | extend SrcUsername = extract(@'User\s(.*?)\sfailed', 1, EventMessage)
  | summarize count() by Site, bin(TimeGenerated, 5m)
  | where count_ > threshold
  | extend SGCustomEntity = Site  
description: |
    'Detects multiple failed logins to same destinations.'
queryFrequency: 1h
triggerThreshold: 0
status: Available

ARM