Claroty - Login to uncommon location

Back


Id	e7dbcbc3-b18f-4635-b27c-718195c369f1
Rulename	Claroty - Login to uncommon location
Description	Detects user login to uncommon location.
Severity	Medium
Tactics	InitialAccess
Techniques	T1190 T1133
Required data connectors	CefAma
Kind	Scheduled
Query frequency	1h
Query period	14d
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Claroty/Analytic Rules/ClarotyLoginToUncommonSite.yaml
Version	1.0.3
Arm template	e7dbcbc3-b18f-4635-b27c-718195c369f1.json

KQL

let usr_sites = ClarotyEvent
| where TimeGenerated > ago(14d)
| where EventType has 'Login to SRA succeeded'
| extend Site = column_ifexists("site_name","")
| where isnotempty(Site)
| extend SrcUsername = extract(@'User\s(.*?)\slogged', 1, EventMessage)
| summarize all_loc = makeset(tostring(Site)) by SrcUsername
| extend k = 1;
ClarotyEvent
| where EventType has 'Login to SRA succeeded'
| extend Site = column_ifexists("site_name","")
| where isnotempty(Site)
| extend SrcUsername = extract(@'User\s(.*?)\slogged', 1, EventMessage)
| extend k = 1
| join kind=innerunique (usr_sites) on k
| where all_loc !contains Site
| extend SrcIpAddr

YAML

entityMappings:
- fieldMappings:
  - identifier: Address
    columnName: SrcIpAddr
  entityType: IP
kind: Scheduled
tactics:
- InitialAccess
query: |
  let usr_sites = ClarotyEvent
  | where TimeGenerated > ago(14d)
  | where EventType has 'Login to SRA succeeded'
  | extend Site = column_ifexists("site_name","")
  | where isnotempty(Site)
  | extend SrcUsername = extract(@'User\s(.*?)\slogged', 1, EventMessage)
  | summarize all_loc = makeset(tostring(Site)) by SrcUsername
  | extend k = 1;
  ClarotyEvent
  | where EventType has 'Login to SRA succeeded'
  | extend Site = column_ifexists("site_name","")
  | where isnotempty(Site)
  | extend SrcUsername = extract(@'User\s(.*?)\slogged', 1, EventMessage)
  | extend k = 1
  | join kind=innerunique (usr_sites) on k
  | where all_loc !contains Site
  | extend SrcIpAddr  
name: Claroty - Login to uncommon location
queryFrequency: 1h
queryPeriod: 14d
triggerThreshold: 0
triggerOperator: gt
severity: Medium
relevantTechniques:
- T1190
- T1133
requiredDataConnectors:
- connectorId: CefAma
  dataTypes:
  - CommonSecurityLog
version: 1.0.3
status: Available
description: |
    'Detects user login to uncommon location.'
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Claroty/Analytic Rules/ClarotyLoginToUncommonSite.yaml
id: e7dbcbc3-b18f-4635-b27c-718195c369f1

ARM