SlackAudit - User email linked to account changed

Back


Id	9d85feb3-7f54-4181-b143-68abb1a86823
Rulename	SlackAudit - User email linked to account changed.
Description	Detects when user email linked to account changes.
Severity	Medium
Tactics	InitialAccess
Techniques	T1078
Required data connectors	SlackAuditAPI
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/SlackAudit/Analytic Rules/SlackAuditUserEmailChanged.yaml
Version	1.0.1
Arm template	9d85feb3-7f54-4181-b143-68abb1a86823.json

KQL

SlackAudit
| where TimeGenerated between (ago(14d) .. (1d))
| summarize max(TimeGenerated) by SrcUserName, SrcUserEmail
| join (SlackAudit 
      | where Action =~ 'user_login'
      | project SrcIpAddr, SrcUserName, NewUserEmail = SrcUserEmail) on SrcUserName
| where NewUserEmail != SrcUserEmail
| extend AccountCustomEntity = SrcUserName
| extend IPCustomEntity = SrcIpAddr

YAML

relevantTechniques:
- T1078
version: 1.0.1
severity: Medium
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/SlackAudit/Analytic Rules/SlackAuditUserEmailChanged.yaml
name: SlackAudit - User email linked to account changed.
customDetails:
  NewUserEmail: NewUserEmail
  OriginalUserEmail: SrcUserEmail
  SourceUserName: SrcUserName
  SourceIpAddress: SrcIpAddr
description: |
    'Detects when user email linked to account changes.'
queryFrequency: 1h
tactics:
- InitialAccess
triggerThreshold: 0
queryPeriod: 14d
id: 9d85feb3-7f54-4181-b143-68abb1a86823
entityMappings:
- fieldMappings:
  - identifier: FullName
    columnName: AccountCustomEntity
  entityType: Account
- fieldMappings:
  - identifier: Address
    columnName: IPCustomEntity
  entityType: IP
requiredDataConnectors:
- connectorId: SlackAuditAPI
  dataTypes:
  - SlackAudit_CL
triggerOperator: gt
alertDetailsOverride:
  alertDisplayNameFormat: Slack user email changed for {{SrcUserName}}
  alertDescriptionFormat: Slack audit detected a user email change for {{SrcUserName}} from {{SrcUserEmail}} to {{NewUserEmail}}.
status: Available
query: |
  SlackAudit
  | where TimeGenerated between (ago(14d) .. (1d))
  | summarize max(TimeGenerated) by SrcUserName, SrcUserEmail
  | join (SlackAudit 
        | where Action =~ 'user_login'
        | project SrcIpAddr, SrcUserName, NewUserEmail = SrcUserEmail) on SrcUserName
  | where NewUserEmail != SrcUserEmail
  | extend AccountCustomEntity = SrcUserName
  | extend IPCustomEntity = SrcIpAddr  
kind: Scheduled

ARM