Apache - Requests to rare files

Back


Id	14d7e15e-3afb-11ec-8d3d-0242ac130003
Rulename	Apache - Requests to rare files
Description	Shows requests to rare files
Severity	Medium
Tactics	InitialAccess
Techniques	T1190 T1133
Required data connectors	CustomLogsAma
Kind	Scheduled
Query frequency	1h
Query period	14d
Trigger threshold	0
Trigger operator	gt
Source Uri	https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/ApacheHTTPServer/Analytic Rules/ApacheRequestToRareFile.yaml
Version	1.0.2
Arm template	14d7e15e-3afb-11ec-8d3d-0242ac130003.json

KQL

let lb_period_start = 14d;
let lb_period_end = 1d;
let known_files = ApacheHTTPServer
| where TimeGenerated between (ago(lb_period_start) .. ago(lb_period_end))
| extend File = extract(@"(.*\/)?(.*)", 2, tostring(UrlOriginal))
| summarize makeset(File);
ApacheHTTPServer
| where TimeGenerated > ago(24h)
| extend File = extract(@"(.*\/)?(.*)", 2, tostring(UrlOriginal))
| where File in~ (known_files)
| extend FileCustomEntity = File, UrlCustomEntity = UrlOriginal

YAML

relevantTechniques:
- T1190
- T1133
entityMappings:
- fieldMappings:
  - columnName: FileCustomEntity
    identifier: Name
  entityType: File
- fieldMappings:
  - columnName: UrlCustomEntity
    identifier: Url
  entityType: URL
triggerThreshold: 0
description: |
    'Shows requests to rare files'
requiredDataConnectors:
- connectorId: CustomLogsAma
  datatypes:
  - ApacheHTTPServer_CL
triggerOperator: gt
version: 1.0.2
OriginalUri: https://github.com/Azure/Azure-Sentinel/blob/master/Solutions/ApacheHTTPServer/Analytic Rules/ApacheRequestToRareFile.yaml
id: 14d7e15e-3afb-11ec-8d3d-0242ac130003
queryFrequency: 1h
query: |
  let lb_period_start = 14d;
  let lb_period_end = 1d;
  let known_files = ApacheHTTPServer
  | where TimeGenerated between (ago(lb_period_start) .. ago(lb_period_end))
  | extend File = extract(@"(.*\/)?(.*)", 2, tostring(UrlOriginal))
  | summarize makeset(File);
  ApacheHTTPServer
  | where TimeGenerated > ago(24h)
  | extend File = extract(@"(.*\/)?(.*)", 2, tostring(UrlOriginal))
  | where File in~ (known_files)
  | extend FileCustomEntity = File, UrlCustomEntity = UrlOriginal  
severity: Medium
status: Available
queryPeriod: 14d
name: Apache - Requests to rare files
tactics:
- InitialAccess
kind: Scheduled

ARM