detection.wiki

Detection rules › Sigma

MSSQL Extended Stored Procedure Backdoor Maggie

Status
test
Severity
high
Log source
product windows, service application
Author
Denis Szadkowski, DIRT / DCSO CyTec
Source
github.com/SigmaHQ/sigma

This rule detects the execution of the extended storage procedure backdoor named Maggie in the context of Microsoft SQL server

Known false positives

  • Legitimate extended stored procedures named maggie

MITRE ATT&CK coverage

TacticTechniques
Persistence
Privilege Escalation

Telemetry coverage

ProviderRecord / event type
MSSQLSERVEREvent ID 8128

Rule body

title: MSSQL Extended Stored Procedure Backdoor Maggie
id: 711ab2fe-c9ba-4746-8840-5228a58c3cb8
status: test
description: This rule detects the execution of the extended storage procedure backdoor named Maggie in the context of Microsoft SQL server
references:
    - https://medium.com/@DCSO_CyTec/mssql-meet-maggie-898773df3b01
author: Denis Szadkowski, DIRT / DCSO CyTec
date: 2022-10-09
tags:
    - attack.privilege-escalation
    - attack.persistence
    - attack.t1546
    - detection.emerging-threats
logsource:
    product: windows
    service: application
detection:
    selection:
        Provider_Name: 'MSSQLSERVER'
        EventID: 8128
        Message|contains: 'maggie'
    condition: selection
falsepositives:
    - Legitimate extended stored procedures named maggie
level: high

Stages and Predicates

Stage 0: condition

selection

Stage 1: selection

selection:
    Provider_Name: 'MSSQLSERVER'
    EventID: 8128
    Message|contains: 'maggie'

Indicators

These rows show field, operator, and value matches.

FieldKindValuesSearch
Messagematch
  • maggie
field:"Message" kind:match value:"maggie"
Provider_Nameeq
  • MSSQLSERVER
field:"Provider_Name" kind:eq value:"MSSQLSERVER"