Oracle - Multiple client errors from single IP

Back


Id	41775080-5740-11ec-bf63-0242ac130002
Rulename	Oracle - Multiple client errors from single IP
Description	Detects multiple client errors from one source in short timeframe
Severity	Medium
Tactics	InitialAccess
Techniques	T1190 T1133
Required data connectors	CustomLogsAma
Kind	Scheduled
Query frequency	1h
Query period	1h
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleWebLogicServer/Analytic Rules/OracleWebLogicMultipleClientErrorsFromSingleIP.yaml
Version	1.0.3
Arm template	41775080-5740-11ec-bf63-0242ac130002.json

KQL

let threshold = 100;
OracleWebLogicServerEvent
| where HttpStatusCode >= 400 and HttpStatusCode <= 499 
| summarize MultipleClientErrors = count() by SrcIpAddr, bin(TimeGenerated, 5m)
| where MultipleClientErrors > threshold
| extend IPCustomEntity = SrcIpAddr

YAML

kind: Scheduled
severity: Medium
status: Available
tactics:
- InitialAccess
entityMappings:
- fieldMappings:
  - columnName: IPCustomEntity
    identifier: Address
  entityType: IP
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleWebLogicServer/Analytic Rules/OracleWebLogicMultipleClientErrorsFromSingleIP.yaml
triggerOperator: gt
triggerThreshold: 0
queryPeriod: 1h
query: |
  let threshold = 100;
  OracleWebLogicServerEvent
  | where HttpStatusCode >= 400 and HttpStatusCode <= 499 
  | summarize MultipleClientErrors = count() by SrcIpAddr, bin(TimeGenerated, 5m)
  | where MultipleClientErrors > threshold
  | extend IPCustomEntity = SrcIpAddr  
description: |
    'Detects multiple client errors from one source in short timeframe'
queryFrequency: 1h
requiredDataConnectors:
- dataTypes:
  - OracleWebLogicServer_CL
  connectorId: CustomLogsAma
version: 1.0.3
name: Oracle - Multiple client errors from single IP
id: 41775080-5740-11ec-bf63-0242ac130002
relevantTechniques:
- T1190
- T1133

ARM