let threshold = 5000;
SophosXGFirewall
| where Log_Type =~ "Firewall" and Status =~ "Deny"
| summarize count() by Src_IP, bin(TimeGenerated,5m)
| where count_ > threshold
triggerThreshold: 0
relevantTechniques:
- T1499
requiredDataConnectors:
- connectorId: SyslogAma
datatypes:
- Syslog
tactics:
- Impact
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/Sophos XG Firewall/Analytic Rules/ExcessiveAmountofDeniedConnectionsfromASingleSource.yaml
queryFrequency: 1h
query: |
let threshold = 5000;
SophosXGFirewall
| where Log_Type =~ "Firewall" and Status =~ "Deny"
| summarize count() by Src_IP, bin(TimeGenerated,5m)
| where count_ > threshold
entityMappings:
- entityType: IP
fieldMappings:
- columnName: Src_IP
identifier: Address
kind: Scheduled
description: |
'This creates an incident in the event that a single source IP address generates a excessive amount of denied connections.'
severity: Medium
id: 3d645a88-2724-41a7-adea-db74c439cf79
status: Available
name: Excessive Amount of Denied Connections from a Single Source
version: 1.0.4
queryPeriod: 1h
triggerOperator: gt