``` 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 ``` | multisearch [ search `rti_dns(vietnam852.com OR site.vietnam852.com OR ftp.vietnam852.com OR server.vietnam852.com OR swordaa.com)` | search 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") | rex field=query "(?i)(?(?:vietnam852\.com|site\.vietnam852\.com|ftp\.vietnam852\.com|server\.vietnam852\.com|swordaa\.com))\.?$" | eval data_model="dns", ioc_type="domain", host=src, detail="DNS query ".query ] [ search `rti_web(vietnam852.com OR site.vietnam852.com OR ftp.vietnam852.com OR server.vietnam852.com OR swordaa.com)` | search 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*", "*site.vietnam852.com:88/ip.php*", "*site.vietnam852.com:88/down.exe*") OR 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") | 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 ] [ search `rti_endpoint(8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d OR f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4 OR 2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379 OR 79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c OR e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9 OR 124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0 OR 125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427 OR 20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0 OR 58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05 OR 2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061 OR da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724 OR 3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0)` | search file_hash IN ("*8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d*", "*f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4*", "*2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379*", "*79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c*", "*e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9*", "*124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0*", "*125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427*", "*20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0*", "*58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05*", "*2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061*", "*da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724*", "*3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0*") OR process_hash IN ("*8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d*", "*f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4*", "*2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379*", "*79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c*", "*e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9*", "*124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0*", "*125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427*", "*20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0*", "*58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05*", "*2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061*", "*da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724*", "*3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0*") OR parent_process_hash IN ("*8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d*", "*f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4*", "*2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379*", "*79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c*", "*e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9*", "*124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0*", "*125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427*", "*20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0*", "*58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05*", "*2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061*", "*da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724*", "*3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0*") | eval matched=file_hash." ".process_hash." ".parent_process_hash | rex field=matched "(?i)(?8ce2cd98ef6ceeece8239936e4aea042c41807f632cd691d5091705bf6c0076d|f5444e8e9e9e019693aacb363b7441ac0b8ecfe96a77fd94b9c312a017588eb4|2a0d2889241885d5ea6fe7dd1b1adc83653a0c07b8aaa1b0832e5f9c0225b379|79596cf6e267ef5cb658bd97d04e42a41001d36595e370441adb3c2b5dd5666c|e9d3fd9093c476b8b5de19aa00c50758568649def6491f54fa3e0aba4ea31ac9|124774698fd3ede0800015d19c2bd6c1869d03bbc2e6e8dbe2f69d2978f7f4d0|125d3a0efe7699bb20397c13f0f4993ad893952727487b4d190e386a5b14c427|20983573b840447e1aacd6d3f6dd240732b15037d268d6456f0d3c4ec5051cb0|58db0ca2054abe2989412d7a1c8ed16718577f893c196825c848fcd56c7e8f05|2a23e10bfc097e98295cbff8124bd403c4cb677e709b48ccc53d6aca216c3061|da4128aa5d006e05c58f0d240c2d8e5fb02774b6acf314f1230059c7a3498724|3f64b0146b323c5716043360e84384a5a197a897f46088df93a910470a29e1a0)" | eval data_model="endpoint", ioc_type=case(len(ioc)==64, "sha256", len(ioc)==40, "sha1", 1==1, "md5"), host=dest, detail=coalesce(process, file_path) ] | fillnull value="-" host user src dest detail | stats count min(_time) AS first_seen max(_time) AS last_seen BY ioc ioc_type data_model host user src dest detail | 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