Data Export From MSSQL Table Via BCP.EXE
Detects the execution of the BCP utility in order to export data from the database. Attackers were seen saving their malware to a database column or table and then later extracting it via "bcp.exe" into a file.
Detection logic
Detection requirements
- Platform
- ESXiIaaSLinuxmacOSNetwork DevicesOffice SuiteSaaSWindows
The rule states no platform. This is derived from the ATT&CK technique it maps to.
- Log source product
- windows
- Log source category
- process_creation
Known benign triggers
- Legitimate data export operations.
MITRE ATT&CK mappings
0 exclusive techniques.This is coverage no other published rule has; it is not this rule's total technique count.
References
| Reference | Cited by |
|---|---|
| asec.ahnlab.com/en/61000/ | Only this detection cites it |
| asec.ahnlab.com/en/78944/ | Only this detection cites it |
| docs.microsoft.com/en-us/sql/tools/bcp-utility | Only this detection cites it |
| news.sophos.com/en-us/2024/08/07/sophos-mdr-hunt-tracks-mimic-ransomware-campaign-against-organizations-in-india/ | Only this detection cites it |
| research.nccgroup.com/2018/03/10/apt15-is-alive-and-strong-an-analysis-of-royalcli-and-royaldns/ | Only this detection cites it |
| www.huntress.com/blog/attacking-mssql-servers | Only this detection cites it |
| www.huntress.com/blog/attacking-mssql-servers-pt-ii | Only this detection cites it |
From the source
- At source
- Open at source
- Upstream identifier
- c615d676-f655-46b9-b913-78729021e5d7
- Tagged by the source as
- attack.executionattack.exfiltration
Licence
- Published under
- Detection Rule License 1.1Read the licence
- Attribution
- Required
Authorship
- Written by
- Published
- Aug 26, 2026
- Version
- 1