MITRE ATT&CK coverage
| Tactic | Techniques |
|---|---|
| Initial Access | |
| Exfiltration |
Rule body
id: edc2f2b4-573f-11ec-bf63-0242ac130002
name: Oracle - Put suspicious file
description: |
'Detects PUT or POST of suspicious file'
severity: Medium
status: Available
requiredDataConnectors:
- connectorId: CustomLogsAma
dataTypes:
- OracleWebLogicServer_CL
queryFrequency: 1h
queryPeriod: 1h
triggerOperator: gt
triggerThreshold: 0
tactics:
- InitialAccess
- Exfiltration
relevantTechniques:
- T1190
- T1133
- T1048
query: |
OracleWebLogicServerEvent
| where HttpRequestMethod in~ ("POST", "PUT")
| extend File = extract(@"(.*\/)?(.*)", 2, tostring(UrlOriginal))
| where isnotempty(File)
| where File matches regex @"([a-zA-Z0-9-_]+\.)([a-zA-Z0-9-]+\.[a-zA-Z0-9-]+)"
| extend IPCustomEntity = SrcIpAddr, FileCustomEntity = File, UrlCustomEntity = UrlOriginal
entityMappings:
- entityType: File
fieldMappings:
- identifier: Name
columnName: FileCustomEntity
- entityType: URL
fieldMappings:
- identifier: Url
columnName: UrlCustomEntity
- entityType: IP
fieldMappings:
- identifier: Address
columnName: IPCustomEntity
version: 1.0.3
kind: Scheduled
Stages and Predicates
Stage 1: source
OracleWebLogicServerEvent
Stage 2: where
| where HttpRequestMethod in~ ("POST", "PUT")
Stage 3: extend
| extend File = extract(@"(.*\/)?(.*)", 2, tostring(UrlOriginal))
Stage 4: where
| where isnotempty(File)
Stage 5: where
| where File matches regex @"([a-zA-Z0-9-_]+\.)([a-zA-Z0-9-]+\.[a-zA-Z0-9-]+)"
Stage 6: extend
| extend IPCustomEntity = SrcIpAddr, FileCustomEntity = File, UrlCustomEntity = UrlOriginal
Indicators
These rows show field, operator, and value matches.
| Field | Kind | Values | Search |
|---|---|---|---|
File | is_not_null | field:"File" kind:is_not_null | |
File | regex_match |
| field:"File" kind:regex_match value:"([a-zA-Z0-9-_]+.)([a-zA-Z0-9-]+.[a-zA-Z0-9-]+)" |
HttpRequestMethod | in |
| field:"HttpRequestMethod" kind:in |
Output fields
These fields are emitted when the rule matches.
| Field | Source |
|---|---|
File | extend |
FileCustomEntity | extend |
IPCustomEntity | extend |
UrlCustomEntity | extend |