Oracle - Request to sensitive files

Back


Id	9cc9ed36-573f-11ec-bf63-0242ac130002
Rulename	Oracle - Request to sensitive files
Description	Detects request to sensitive files.
Severity	High
Tactics	InitialAccess
Techniques	T1189
Required data connectors	CustomLogsAma
Kind	Scheduled
Query frequency	15m
Query period	15m
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleWebLogicServer/Analytic Rules/OracleWebLogicRequestToSensitiveFiles.yaml
Version	1.0.3
Arm template	9cc9ed36-573f-11ec-bf63-0242ac130002.json

KQL

let forbidden_files = dynamic(['shadow', 'passwd', 'hosts', 'id_rsa']);
OracleWebLogicServerEvent    
| extend File = extract(@'(.*\/)?(.*)', 2, tostring(UrlOriginal))
| where isnotempty(File)
| where File in~ (forbidden_files)
| extend FileCustomEntity = File, UrlCustomEntity = UrlOriginal

YAML

name: Oracle - Request to sensitive files
query: |
  let forbidden_files = dynamic(['shadow', 'passwd', 'hosts', 'id_rsa']);
  OracleWebLogicServerEvent    
  | extend File = extract(@'(.*\/)?(.*)', 2, tostring(UrlOriginal))
  | where isnotempty(File)
  | where File in~ (forbidden_files)
  | extend FileCustomEntity = File, UrlCustomEntity = UrlOriginal  
queryFrequency: 15m
triggerOperator: gt
requiredDataConnectors:
- dataTypes:
  - OracleWebLogicServer_CL
  connectorId: CustomLogsAma
status: Available
entityMappings:
- entityType: File
  fieldMappings:
  - identifier: Name
    columnName: FileCustomEntity
- entityType: URL
  fieldMappings:
  - identifier: Url
    columnName: UrlCustomEntity
triggerThreshold: 0
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleWebLogicServer/Analytic Rules/OracleWebLogicRequestToSensitiveFiles.yaml
description: |
    'Detects request to sensitive files.'
version: 1.0.3
id: 9cc9ed36-573f-11ec-bf63-0242ac130002
kind: Scheduled
relevantTechniques:
- T1189
severity: High
tactics:
- InitialAccess
queryPeriod: 15m

ARM