Oracle - Multiple user agents for single source

Back


Id	44c7d12a-573f-11ec-bf63-0242ac130002
Rulename	Oracle - Multiple user agents for single source
Description	Detects requests with different user agents 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/OracleWebLogicDifferentUAsFromSingleIP.yaml
Version	1.0.3
Arm template	44c7d12a-573f-11ec-bf63-0242ac130002.json

KQL

let threshold = 5;
OracleWebLogicServerEvent
| where isnotempty(HttpUserAgentOriginal)
| summarize ua_count=makeset(HttpUserAgentOriginal) by SrcIpAddr, bin(TimeGenerated, 5m)
| where array_length(ua_count) > threshold
| extend IPCustomEntity = SrcIpAddr

YAML

entityMappings:
- entityType: IP
  fieldMappings:
  - identifier: Address
    columnName: IPCustomEntity
tactics:
- InitialAccess
requiredDataConnectors:
- dataTypes:
  - OracleWebLogicServer_CL
  connectorId: CustomLogsAma
id: 44c7d12a-573f-11ec-bf63-0242ac130002
severity: Medium
status: Available
query: |
  let threshold = 5;
  OracleWebLogicServerEvent
  | where isnotempty(HttpUserAgentOriginal)
  | summarize ua_count=makeset(HttpUserAgentOriginal) by SrcIpAddr, bin(TimeGenerated, 5m)
  | where array_length(ua_count) > threshold
  | extend IPCustomEntity = SrcIpAddr  
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleWebLogicServer/Analytic Rules/OracleWebLogicDifferentUAsFromSingleIP.yaml
kind: Scheduled
queryPeriod: 1h
version: 1.0.3
name: Oracle - Multiple user agents for single source
queryFrequency: 1h
triggerThreshold: 0
relevantTechniques:
- T1190
- T1133
description: |
    'Detects requests with different user agents from one source in short timeframe.'
triggerOperator: gt

ARM