detection.wiki

Detection rules › Kusto

Tomcat - Sql injection patterns

Status
available
Severity
high
Time window
1h
Source
github.com/Azure/Azure-Sentinel

'Detects possible sql injection patterns'

MITRE ATT&CK coverage

TacticTechniques
Initial Access

Rule body

id: ce84741e-4875-11ec-81d3-0242ac130003
name: Tomcat - Sql injection patterns
description: |
  'Detects possible sql injection patterns'
severity: High
status: Available
requiredDataConnectors:
  - connectorId: CustomLogsAma
    datatypes:
      - Tomcat_CL
queryFrequency: 1h
queryPeriod: 1h
triggerOperator: gt
triggerThreshold: 0
tactics:
  - InitialAccess
relevantTechniques:
  - T1190
query: |
  let commands = dynamic(["1/*'*/", "1'||'asd'||'", "'1'='1", "1' or '1'='1", "1 or 1=1", "1=1", "1/*!1111'*/", "'or''='"]);
  TomcatEvent
  | where UrlOriginal has_any (commands)
  | extend UrlCustomEntity = UrlOriginal
entityMappings:
  - entityType: URL
    fieldMappings:
      - identifier: Url
        columnName: UrlCustomEntity
version: 1.0.2
kind: Scheduled

Stages and Predicates

Let binding: commands used in Stage 2

let commands = dynamic(["1/*'*/", "1'||'asd'||'", "'1'='1", "1' or '1'='1", "1 or 1=1", "1=1", "1/*!1111'*/", "'or''='"]);

Stage 1: source

TomcatEvent

Stage 2: where

| where UrlOriginal has_any (commands)

Stage 3: extend

| extend UrlCustomEntity = UrlOriginal

Indicators

These rows show field, operator, and value matches.

FieldKindValuesSearch
UrlOriginalmatch
  • '1'='1 transforms: term
  • 'or''=' transforms: term
  • 1 or 1=1 transforms: term
  • 1' or '1'='1 transforms: term
  • 1'||'asd'||' transforms: term
  • 1/*!1111'*/ transforms: term
  • 1/*'*/ transforms: term
  • 1=1 transforms: term
field:"UrlOriginal" kind:match

Output fields

These fields are emitted when the rule matches.

FieldSource
UrlCustomEntityextend