``` 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 ``` | tstats summariesonly=false fillnull_value="-" count min(_time) AS first_seen max(_time) AS last_seen FROM datamodel=Network_Resolution.DNS WHERE DNS.query IN ("vietnam852.com", "*.vietnam852.com", "site.vietnam852.com", "*.site.vietnam852.com", "ftp.vietnam852.com", "*.ftp.vietnam852.com", "server.vietnam852.com", "*.server.vietnam852.com", "swordaa.com", "*.swordaa.com") BY DNS.src DNS.dest DNS.query DNS.reply_code | rename "DNS.*" AS * | rex field=query "(?i)(?(?:vietnam852\.com|site\.vietnam852\.com|ftp\.vietnam852\.com|server\.vietnam852\.com|swordaa\.com))\.?$" | eval data_model="Network_Resolution", ioc_type="domain", host=src, user="-", detail="DNS query ".query." (".reply_code.")" | append [ | tstats summariesonly=false fillnull_value="-" count min(_time) AS first_seen max(_time) AS last_seen FROM datamodel=Web.Web WHERE (Web.url IN ("*://vietnam852.com*", "*.vietnam852.com*", "vietnam852.com*", "*://site.vietnam852.com*", "*.site.vietnam852.com*", "site.vietnam852.com*", "*://ftp.vietnam852.com*", "*.ftp.vietnam852.com*", "ftp.vietnam852.com*", "*://server.vietnam852.com*", "*.server.vietnam852.com*", "server.vietnam852.com*", "*://swordaa.com*", "*.swordaa.com*", "swordaa.com*") OR Web.dest IN ("vietnam852.com", "*.vietnam852.com", "site.vietnam852.com", "*.site.vietnam852.com", "ftp.vietnam852.com", "*.ftp.vietnam852.com", "server.vietnam852.com", "*.server.vietnam852.com", "swordaa.com", "*.swordaa.com") OR Web.url IN ("*site.vietnam852.com:88/ip.php*", "*site.vietnam852.com:88/down.exe*")) BY Web.src Web.user Web.dest Web.url Web.http_user_agent Web.status | rename "Web.*" AS * | rex field=url "(?i)(?site\.vietnam852\.com:88/ip\.php|site\.vietnam852\.com:88/down\.exe|vietnam852\.com|site\.vietnam852\.com|ftp\.vietnam852\.com|server\.vietnam852\.com|swordaa\.com)" | eval ioc=coalesce(ioc, dest), data_model="Web", ioc_type=if(match(ioc, "/"), "url", "domain"), host=src, detail="HTTP ".status." ".url." UA: ".http_user_agent ] | append [ | tstats summariesonly=false fillnull_value="-" count min(_time) AS first_seen max(_time) AS last_seen FROM datamodel=Endpoint.Processes WHERE Processes.process_hash IN ("*8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d*", "*f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4*", "*2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379*", "*79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c*", "*e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9*", "*124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0*", "*125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427*", "*20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0*", "*58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05*", "*2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061*", "*da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724*", "*3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0*") BY Processes.dest Processes.user Processes.process_name Processes.process_path Processes.parent_process_name Processes.process_hash | rename "Processes.*" AS * | rex field=process_hash "(?i)(?8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d|f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4|2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379|79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c|e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9|124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0|125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427|20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0|58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05|2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061|da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724|3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0)" | eval data_model="Endpoint.Processes", ioc_type=case(len(ioc)==64, "sha256", len(ioc)==40, "sha1", 1==1, "md5"), host=dest, src="-", detail="process ".process_path." (parent ".parent_process_name.")" ] | append [ | tstats summariesonly=false fillnull_value="-" count min(_time) AS first_seen max(_time) AS last_seen FROM datamodel=Endpoint.Processes WHERE Processes.parent_process_hash IN ("*8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d*", "*f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4*", "*2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379*", "*79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c*", "*e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9*", "*124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0*", "*125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427*", "*20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0*", "*58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05*", "*2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061*", "*da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724*", "*3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0*") BY Processes.dest Processes.user Processes.process_name Processes.process_path Processes.parent_process_name Processes.parent_process_hash | rename "Processes.*" AS * | rex field=parent_process_hash "(?i)(?8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d|f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4|2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379|79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c|e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9|124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0|125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427|20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0|58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05|2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061|da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724|3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0)" | eval data_model="Endpoint.Processes", ioc_type=case(len(ioc)==64, "sha256", len(ioc)==40, "sha1", 1==1, "md5"), host=dest, src="-", detail="parent process ".process_path." (parent ".parent_process_name.")" ] | append [ | tstats summariesonly=false fillnull_value="-" count min(_time) AS first_seen max(_time) AS last_seen FROM datamodel=Endpoint.Filesystem WHERE Filesystem.file_hash IN ("*8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d*", "*f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4*", "*2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379*", "*79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c*", "*e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9*", "*124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0*", "*125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427*", "*20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0*", "*58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05*", "*2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061*", "*da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724*", "*3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0*") BY Filesystem.dest Filesystem.user Filesystem.file_path Filesystem.file_name Filesystem.action Filesystem.file_hash | rename "Filesystem.*" AS * | rex field=file_hash "(?i)(?8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d|f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4|2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379|79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c|e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9|124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0|125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427|20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0|58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05|2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061|da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724|3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0)" | eval data_model="Endpoint.Filesystem", ioc_type=case(len(ioc)==64, "sha256", len(ioc)==40, "sha1", 1==1, "md5"), host=dest, src="-", detail="file ".action." ".file_path ] | append [ | tstats summariesonly=false fillnull_value="-" count min(_time) AS first_seen max(_time) AS last_seen FROM datamodel=Email.All_Email WHERE (All_Email.file_hash IN ("*8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d*", "*f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4*", "*2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379*", "*79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c*", "*e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9*", "*124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0*", "*125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427*", "*20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0*", "*58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05*", "*2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061*", "*da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724*", "*3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0*") OR All_Email.url IN ("*site.vietnam852.com:88/ip.php*", "*site.vietnam852.com:88/down.exe*", "*://vietnam852.com*", "*.vietnam852.com*", "vietnam852.com*", "*://site.vietnam852.com*", "*.site.vietnam852.com*", "site.vietnam852.com*", "*://ftp.vietnam852.com*", "*.ftp.vietnam852.com*", "ftp.vietnam852.com*", "*://server.vietnam852.com*", "*.server.vietnam852.com*", "server.vietnam852.com*", "*://swordaa.com*", "*.swordaa.com*", "swordaa.com*")) BY All_Email.src_user All_Email.recipient All_Email.subject All_Email.file_name All_Email.file_hash All_Email.url | rename "All_Email.*" AS * | eval matched=file_hash." ".url | rex field=matched "(?i)(?8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d|f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4|2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379|79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c|e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9|124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0|125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427|20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0|58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05|2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061|da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724|3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0|site\.vietnam852\.com:88/ip\.php|site\.vietnam852\.com:88/down\.exe|vietnam852\.com|site\.vietnam852\.com|ftp\.vietnam852\.com|server\.vietnam852\.com|swordaa\.com)" | eval data_model="Email", ioc_type=case(match(ioc, "^[0-9a-fA-F]{64}$"), "sha256", match(ioc, "^[0-9a-fA-F]{40}$"), "sha1", match(ioc, "^[0-9a-fA-F]{32}$"), "md5", match(ioc, "/"), "url", 1==1, "domain"), host="-", user=recipient, src=src_user, dest=recipient, detail="email '".subject."' ".file_name ] | sort 0 - last_seen | eval first_seen=strftime(first_seen, "%Y-%m-%d %H:%M:%S"), last_seen=strftime(last_seen, "%Y-%m-%d %H:%M:%S") | table first_seen last_seen ioc ioc_type data_model host user src dest detail count