CmdID / Rules / Windows

Data Export From MSSQL Table Via BCP.EXE

A Sigma rule for process creation on Windows, by Omar Khaled (@beacon_exe), MahirAli Khan (in/mahiralikhan), Nasreddine Bencherchali (Nextron Systems).

medium 1 ATT&CK technique 1 program it names

What it looks for

its detection, as SigmaHQ writes it

detection:
  selection_cli:
    CommandLine|contains:
      - ' out '
      - ' queryout '
  selection_img:
    - Image|endswith: '\bcp.exe'
    - OriginalFileName: 'BCP.exe'
  condition: all of selection_*

The rule’s detection, its selections and fields in order of name. The whole rule, with its references and false positives, is on SigmaHQ, by Omar Khaled (@beacon_exe), MahirAli Khan (in/mahiralikhan), Nasreddine Bencherchali (Nextron Systems), under the Detection Rule License 1.1. CmdID evaluates it on a command line alone: a test on what a command line cannot show, such as the parent process or the user, is not met.

Command lines that trip it

documented abuse, read by CmdID

The commands LOLBAS or GTFOBins documents for bcp.exe trip it: each is on its program’s page, read by CmdID.

Programs and files it names

their pages here

bcp.exe

ATT&CK

the techniques it is tagged with

T1048Exfiltration Over Alternative Protocol

Data Export From MSSQL Table Via BCP.EXE

What it looks for

Command lines that trip it

Programs and files it names

ATT&CK

Other rules for T1048 Exfiltration Over Alternative Protocol