// Threat: MSSQL T-SQL Brute-Force Campaign Delivering an XMRig Miner and Gh0st RAT // Author: Daniel Jeremiah | Date: 2026-11-12 // Ref: https://github.com/daniyyell-dev/rapid-threat-intel/tree/main/threats/2026-11_November-2026/2026-11-12/MSSQL-T-SQL-Brute-Force-Miner-Gh0st-RAT let Lookback = 30d; let Domains = dynamic(["vietnam852.com", "site.vietnam852.com", "ftp.vietnam852.com", "server.vietnam852.com", "swordaa.com"]); let Urls = dynamic(["http://site.vietnam852.com:88/ip.php", "http://site.vietnam852.com:88/down.exe"]); let UrlKeys = dynamic(["site.vietnam852.com:88/ip.php", "site.vietnam852.com:88/down.exe"]); let SHA256s = dynamic(["8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d", "f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4", "2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379", "79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c", "e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9", "124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0", "125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427", "20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0", "58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05", "2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061", "da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724", "3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0"]); union isfuzzy=true (DeviceNetworkEvents | where Timestamp > ago(Lookback) | where RemoteUrl has_any (Domains) | project Timestamp, SourceTable = "DeviceNetworkEvents", Entity = tostring(DeviceName), Indicator = tostring(RemoteUrl), Context = tostring(strcat(ActionType, " ", InitiatingProcessFileName, " ", RemoteIP))), (DeviceEvents | where Timestamp > ago(Lookback) | where ActionType == "DnsQueryResponse" and tostring(parse_json(AdditionalFields).DnsQueryString) has_any (Domains) | project Timestamp, SourceTable = "DeviceEvents", Entity = tostring(DeviceName), Indicator = tostring(parse_json(AdditionalFields).DnsQueryString), Context = tostring(strcat("DNS ", InitiatingProcessFileName))), (DeviceNetworkEvents | where Timestamp > ago(Lookback) | where RemoteUrl has_any (UrlKeys) | project Timestamp, SourceTable = "DeviceNetworkEvents", Entity = tostring(DeviceName), Indicator = tostring(RemoteUrl), Context = tostring(strcat(ActionType, " ", InitiatingProcessFileName, " ", RemoteIP))), (EmailUrlInfo | where Timestamp > ago(Lookback) | where UrlDomain has_any (Domains) or Url has_any (UrlKeys) | project Timestamp, SourceTable = "EmailUrlInfo", Entity = tostring(NetworkMessageId), Indicator = tostring(Url), Context = tostring("URL in email")), (UrlClickEvents | where Timestamp > ago(Lookback) | where Url has_any (Domains) or Url has_any (UrlKeys) | project Timestamp, SourceTable = "UrlClickEvents", Entity = tostring(AccountUpn), Indicator = tostring(Url), Context = tostring(strcat(ActionType, " ", Workload))), (DeviceFileEvents | where Timestamp > ago(Lookback) | where SHA256 in~ (SHA256s) | project Timestamp, SourceTable = "DeviceFileEvents", Entity = tostring(DeviceName), Indicator = tostring(SHA256), Context = tostring(strcat(ActionType, " ", FolderPath))), (DeviceProcessEvents | where Timestamp > ago(Lookback) | where SHA256 in~ (SHA256s) | project Timestamp, SourceTable = "DeviceProcessEvents", Entity = tostring(DeviceName), Indicator = tostring(SHA256), Context = tostring(strcat(FolderPath, " ", ProcessCommandLine))), (DeviceImageLoadEvents | where Timestamp > ago(Lookback) | where SHA256 in~ (SHA256s) | project Timestamp, SourceTable = "DeviceImageLoadEvents", Entity = tostring(DeviceName), Indicator = tostring(SHA256), Context = tostring(strcat(FolderPath, " loaded by ", InitiatingProcessFileName))), (EmailAttachmentInfo | where Timestamp > ago(Lookback) | where SHA256 in~ (SHA256s) | project Timestamp, SourceTable = "EmailAttachmentInfo", Entity = tostring(RecipientEmailAddress), Indicator = tostring(SHA256), Context = tostring(strcat(FileName, " from ", SenderFromAddress))) | summarize FirstSeen = min(Timestamp), LastSeen = max(Timestamp), Hits = count(), Context = take_any(Context) by SourceTable, Entity, Indicator | order by LastSeen desc