Detection rules › Kusto
Sentinel One - Admin login from new location
'Detects admin user login from new location (IP address).'
MITRE ATT&CK coverage
| Tactic | Techniques |
|---|---|
| Initial Access | |
| Privilege Escalation |
Rule body
id: 382f37b3-b49a-492f-b436-a4717c8c5c3e
name: Sentinel One - Admin login from new location
description: |
'Detects admin user login from new location (IP address).'
severity: High
status: Available
requiredDataConnectors:
- connectorId: SentinelOne
dataTypes:
- SentinelOne
queryFrequency: 1h
queryPeriod: 14d
triggerOperator: gt
triggerThreshold: 0
tactics:
- InitialAccess
- PrivilegeEscalation
relevantTechniques:
- T1078
query: |
let lback_period = 14d;
let lback_time = 1h;
SentinelOne
| where TimeGenerated between(ago(lback_period)..ago(lback_time))
| where ActivityType == 27
| where DataRole =~ 'Admin'
| extend SrcIpAddr = extract(@'Address\s(\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})', 1, EventOriginalMessage)
| where isnotempty(SrcIpAddr)
| summarize ip_lst = makeset(SrcIpAddr) by SrcUserName
| join (SentinelOne
| where ActivityType == 27
| where DataRole =~ 'Admin'
| extend SrcIpAddr = extract(@'Address\s(\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})', 1, EventOriginalMessage)
| where isnotempty(SrcIpAddr)) on SrcUserName
| where ip_lst !has SrcIpAddr
| extend AccountCustomEntity = SrcUserName, IPCustomEntity = SrcIpAddr
entityMappings:
- entityType: Account
fieldMappings:
- identifier: Name
columnName: AccountCustomEntity
- entityType: IP
fieldMappings:
- identifier: Address
columnName: IPCustomEntity
version: 1.0.1
kind: Scheduled
Stages and Predicates
Parameters
let lback_period = 14d;
let lback_time = 1h;
Stage 1: source
SentinelOne
Stage 2: where
| where TimeGenerated between(ago(lback_period)..ago(lback_time))
Stage 3: where
| where ActivityType == 27
Stage 4: where
| where DataRole =~ 'Admin'
Stage 5: extend
| extend SrcIpAddr = extract(@'Address\s(\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})', 1, EventOriginalMessage)
Stage 6: where
| where isnotempty(SrcIpAddr)
Stage 7: summarize
| summarize ip_lst = makeset(SrcIpAddr) by SrcUserName
Stage 8: join
| join (SentinelOne
| where ActivityType == 27
| where DataRole =~ 'Admin'
| extend SrcIpAddr = extract(@'Address\s(\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})', 1, EventOriginalMessage)
| where isnotempty(SrcIpAddr)) on SrcUserName
Stage 9: where
| where ip_lst !has SrcIpAddr
Stage 10: extend
| extend AccountCustomEntity = SrcUserName, IPCustomEntity = SrcIpAddr
Indicators
These rows show field, operator, and value matches.
| Field | Kind | Values | Search |
|---|---|---|---|
ActivityType | eq |
| field:"ActivityType" kind:eq value:"27" |
DataRole | eq |
| field:"DataRole" kind:eq value:"Admin" |
SrcIpAddr | is_not_null | field:"src_ip" kind:is_not_null | |
ip_lst | cross_field_compare |
| field:"ip_lst" kind:cross_field_compare value:"SrcIpAddr" |
Output fields
These fields are emitted when the rule matches.
| Field | Source |
|---|---|
SrcUserName | summarize |
ip_lst | summarize |
AccountCustomEntity | extend |
IPCustomEntity | extend |