Cisco Duo - Multiple user login failures

let threshold = 10;
CiscoDuo
| where EventType =~ 'authentication'
| where EventResult in~ ('denied', 'failure')
| summarize count() by DstUserName, bin(TimeGenerated, 10m)
| where count_ > threshold
| extend AccountCustomEntity = DstUserName

queryPeriod: 1h
description: |
    'Detects when multiple user login failures occurs.'
kind: Scheduled
query: |
  let threshold = 10;
  CiscoDuo
  | where EventType =~ 'authentication'
  | where EventResult in~ ('denied', 'failure')
  | summarize count() by DstUserName, bin(TimeGenerated, 10m)
  | where count_ > threshold
  | extend AccountCustomEntity = DstUserName  
tactics:
- InitialAccess
triggerOperator: gt
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/CiscoDuoSecurity/Analytic Rules/CiscoDuoMultipleUserLoginFailures.yaml
id: 034f62b6-df51-49f3-831f-1e4cfd3c40d2
version: 1.0.1
entityMappings:
- entityType: Account
  fieldMappings:
  - identifier: Name
    columnName: AccountCustomEntity
triggerThreshold: 0
status: Available
relevantTechniques:
- T1078
name: Cisco Duo - Multiple user login failures
severity: High
requiredDataConnectors:
- dataTypes:
  - CiscoDuo
  connectorId: CiscoDuoSecurity
queryFrequency: 1h