let threshold = 5;
VersasecCmsSysLogs
| where EventId == 2
| sort by ComputerName asc, TimeGenerated asc
| extend TimeDiff = datetime_diff('minute', TimeGenerated, prev(TimeGenerated))
| where TimeDiff <= threshold and ComputerName == prev(ComputerName)
name: Versasec CMS - Multiple Failed Login Attempts
kind: Scheduled
tactics:
- CredentialAccess
triggerThreshold: 5
triggerOperator: gt
version: 1.0.1
status: Available
incidentConfiguration:
createIncident: true
groupingConfiguration:
matchingMethod: AllEntities
enabled: false
lookbackDuration: 5m
reopenClosedIncident: false
queryFrequency: 5m
id: B1DB8B7E-9D74-48C3-9683-74483CBEFF4E
requiredDataConnectors:
- connectorId: VersasecCms
dataTypes:
- VersasecCmsSysLogs
eventGroupingSettings:
aggregationKind: SingleAlert
relevantTechniques:
- T1110
description: |
Detects when Operator login failed to often.
entityMappings:
- entityType: Host
fieldMappings:
- columnName: ComputerName
identifier: FullName
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/VersasecCMS/Analytic Rules/VersasecCmsOperatorLoginFailed.yaml
queryPeriod: 1h
severity: High
query: |
let threshold = 5;
VersasecCmsSysLogs
| where EventId == 2
| sort by ComputerName asc, TimeGenerated asc
| extend TimeDiff = datetime_diff('minute', TimeGenerated, prev(TimeGenerated))
| where TimeDiff <= threshold and ComputerName == prev(ComputerName)