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)
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/VersasecCMS/Analytic Rules/VersasecCmsOperatorLoginFailed.yaml
queryPeriod: 1h
description: |
Detects when Operator login failed to often.
triggerThreshold: 5
name: Versasec CMS - Multiple Failed Login Attempts
triggerOperator: gt
entityMappings:
- entityType: Host
fieldMappings:
- identifier: FullName
columnName: ComputerName
kind: Scheduled
requiredDataConnectors:
- connectorId: VersasecCms
dataTypes:
- VersasecCmsSysLogs
eventGroupingSettings:
aggregationKind: SingleAlert
queryFrequency: 5m
incidentConfiguration:
createIncident: true
groupingConfiguration:
matchingMethod: AllEntities
enabled: false
reopenClosedIncident: false
lookbackDuration: 5m
tactics:
- CredentialAccess
id: B1DB8B7E-9D74-48C3-9683-74483CBEFF4E
status: Available
version: 1.0.1
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)
severity: High
relevantTechniques:
- T1110