Ping Federate - New user SSO success login

Status: available
Severity: low
Time window: 14d
Source: github.com/Azure/Azure-Sentinel

'Detects new user SSO success login.'

MITRE ATT&CK coverage

Tactic	Techniques
Initial Access	`T1078` Valid Accounts
Persistence	`T1078` Valid Accounts `T1136` Create Account

Rule body

id: 05282c91-7aaf-4d76-9a19-6dc582e6a411
name: Ping Federate - New user SSO success login
description: |
  'Detects new user SSO success login.'
severity: Low
status: Available
requiredDataConnectors:
  - connectorId: CefAma
    dataTypes:
      - CommonSecurityLog
queryFrequency: 1h
queryPeriod: 14d
triggerOperator: gt
triggerThreshold: 0
tactics:
  - InitialAccess
  - Persistence
relevantTechniques:
  - T1078
  - T1136
query: |
  let known_usrs = 
  PingFederateEvent
  | where TimeGenerated between (ago(14d) .. (1d))
  | where isnotempty(DstUserName)
  | summarize makeset(DstUserName);
  PingFederateEvent
  | where EventType =~ 'SSO'
  | where EventMessage has 'success'
  | where DstUserName !in (known_usrs)
  | extend AccountCustomEntity = DstUserName
entityMappings:
  - entityType: Account
    fieldMappings:
      - identifier: Name
        columnName: AccountCustomEntity
version: 1.0.3
kind: Scheduled

Stages and Predicates

Let binding: `known_usrs` used in Stage 4

let known_usrs = PingFederateEvent
| where TimeGenerated between (ago(14d) .. (1d))
| where isnotempty(DstUserName)
| summarize makeset(DstUserName);

Stage 1: `source`

PingFederateEvent

Stage 2: `where`

| where EventType =~ 'SSO'

Stage 3: `where`

| where EventMessage has 'success'

Stage 4: `where`

| where DstUserName !in (known_usrs)

Stage 5: `extend`

| extend AccountCustomEntity = DstUserName

Exclusions

The rule actively suppresses these predicates.

Field	Kind	Excluded values	Search
`DstUserName`	eq	`known_usrs`	`excludes:DstUserName` `field:"DstUserName" value:"known_usrs"`

Indicators

These rows show field, operator, and value matches.

Field	Kind	Values	Search
`EventMessage`	match	`success` transforms: `term`	`field:"EventMessage" kind:match value:"success"`
`EventType`	eq	`SSO`	`field:"EventType" kind:eq value:"SSO"`

Output fields

These fields are emitted when the rule matches.

Field	Source
`AccountCustomEntity`	`extend`

Ping Federate - New user SSO success login

MITRE ATT&CK coverage

Rule body

Stages and Predicates

Let binding: known_usrs used in Stage 4

Stage 1: source

Stage 2: where

Stage 3: where

Stage 4: where

Stage 5: extend

Exclusions

Indicators

Output fields

Let binding: `known_usrs` used in Stage 4

Stage 1: `source`

Stage 2: `where`

Stage 3: `where`

Stage 4: `where`

Stage 5: `extend`