Oracle - Private IP in URL

Back


Id	153ce6d8-5740-11ec-bf63-0242ac130002
Rulename	Oracle - Private IP in URL
Description	Detects requests to unusual URL
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/OracleWebLogicPrivateIpInUrl.yaml
Version	1.0.3
Arm template	153ce6d8-5740-11ec-bf63-0242ac130002.json

KQL

OracleWebLogicServerEvent
| where isnotempty(UrlOriginal)
| where UrlOriginal matches regex @'(10\.\d{1,3}\.\d{1,3}\.\d{1,3})|(172\.1[6-9]\.\d{1,3}\.\d{1,3})|(172\.2[0-9]\.\d{1,3}\.\d{1,3})|(172\.3[0-1]\.\d{1,3}\.\d{1,3})|(192\.168\.\d{1,3}\.\d{1,3})'
| extend IPCustomEntity = SrcIpAddr, UrlCustomEntity = UrlOriginal

YAML

description: |
    'Detects requests to unusual URL'
requiredDataConnectors:
- dataTypes:
  - OracleWebLogicServer_CL
  connectorId: CustomLogsAma
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/OracleWebLogicServer/Analytic Rules/OracleWebLogicPrivateIpInUrl.yaml
id: 153ce6d8-5740-11ec-bf63-0242ac130002
name: Oracle - Private IP in URL
relevantTechniques:
- T1190
- T1133
triggerThreshold: 0
entityMappings:
- fieldMappings:
  - identifier: Url
    columnName: UrlCustomEntity
  entityType: URL
- fieldMappings:
  - identifier: Address
    columnName: IPCustomEntity
  entityType: IP
kind: Scheduled
version: 1.0.3
triggerOperator: gt
query: |
  OracleWebLogicServerEvent
  | where isnotempty(UrlOriginal)
  | where UrlOriginal matches regex @'(10\.\d{1,3}\.\d{1,3}\.\d{1,3})|(172\.1[6-9]\.\d{1,3}\.\d{1,3})|(172\.2[0-9]\.\d{1,3}\.\d{1,3})|(172\.3[0-1]\.\d{1,3}\.\d{1,3})|(192\.168\.\d{1,3}\.\d{1,3})'
  | extend IPCustomEntity = SrcIpAddr, UrlCustomEntity = UrlOriginal  
status: Available
tactics:
- InitialAccess
queryPeriod: 1h
severity: Medium
queryFrequency: 1h

ARM