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

description: |
    'Detects user login to uncommon location.'
entityMappings:
- fieldMappings:
  - columnName: SrcIpAddr
    identifier: Address
  entityType: IP
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  
tactics:
- InitialAccess
severity: Medium
triggerThreshold: 0
queryFrequency: 1h
status: Available
queryPeriod: 14d
relevantTechniques:
- T1190
- T1133
id: e7dbcbc3-b18f-4635-b27c-718195c369f1
name: Claroty - Login to uncommon location
kind: Scheduled
triggerOperator: gt
version: 1.0.3
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Claroty/Analytic Rules/ClarotyLoginToUncommonSite.yaml
requiredDataConnectors:
- dataTypes:
  - CommonSecurityLog
  connectorId: CefAma

ARM