``` Threat: CopperDragon: China-Nexus Sparrow Framework Targeting Government and Telecoms Author: Daniel Jeremiah | Date: 2026-11-10 Ref: https://github.com/daniyyell-dev/rapid-threat-intel/tree/main/threats/2026-11_November-2026/2026-11-10/CopperDragon-Sparrow-Framework-China-Nexus-Espionage ``` | tstats summariesonly=false fillnull_value="-" count min(_time) AS first_seen max(_time) AS last_seen FROM datamodel=Network_Traffic.All_Traffic WHERE All_Traffic.dest_ip IN ("135.136.135.54", "103.141.235.123", "109.205.195.131", "158.255.213.189", "165.154.227.16", "45.197.12.11", "91.210.164.5", "103.215.216.117", "103.215.216.116", "103.215.216.125", "103.215.216.197", "103.215.216.27", "103.215.216.75", "103.215.216.186", "103.215.216.162", "103.215.216.123", "149.104.90.200", "151.242.188.220", "180.149.44.43", "180.149.44.115", "194.213.18.178", "2.56.222.28", "2.56.222.49", "216.185.57.152", "217.69.13.77", "38.54.71.107", "38.54.71.56", "38.54.71.160", "45.80.208.195", "45.80.208.232", "45.80.208.66", "45.86.230.60", "45.90.58.202", "47.81.8.145", "89.223.91.91", "89.44.193.140", "160.16.83.208", "153.127.55.77", "134.255.211.224", "207.189.10.188", "91.227.77.172", "165.154.226.247", "165.154.243.24", "38.60.209.227", "216.238.118.179", "216.238.123.242", "64.190.113.170", "154.223.21.194", "154.205.154.82", "154.205.154.70", "37.122.150.133", "38.60.195.184", "103.9.77.116", "87.236.37.185", "92.118.127.23", "130.94.91.53", "45.39.103.5", "38.54.57.12", "38.54.45.155", "38.60.206.85", "38.60.209.65", "38.60.242.182", "38.60.241.65", "38.60.214.237", "149.104.87.222", "156.244.2.26", "149.104.12.128", "181.41.201.244", "38.60.241.193", "149.104.87.228", "77.111.101.153", "77.111.101.227", "77.111.101.11", "216.238.110.120", "216.238.71.215", "216.238.73.14", "216.238.111.30", "216.238.119.130", "216.238.90.160", "216.238.85.243", "216.238.107.140", "216.238.115.152", "64.176.10.7", "64.176.6.27", "45.76.215.17", "185.93.173.30", "188.214.157.51", "108.61.161.250", "167.179.109.141", "216.238.106.177", "216.238.113.122", "216.238.121.254", "216.238.120.8") BY All_Traffic.src_ip All_Traffic.dest_ip All_Traffic.dest_port All_Traffic.action All_Traffic.dvc All_Traffic.user | rename "All_Traffic.*" AS * | eval data_model="Network_Traffic", ioc_type="ipv4", ioc=dest_ip, host=dvc, src=src_ip, dest=dest_ip, detail="connection to IOC, port ".dest_port.", ".action | append [ | tstats summariesonly=false fillnull_value="-" count min(_time) AS first_seen max(_time) AS last_seen FROM datamodel=Network_Traffic.All_Traffic WHERE All_Traffic.src_ip IN ("135.136.135.54", "103.141.235.123", "109.205.195.131", "158.255.213.189", "165.154.227.16", "45.197.12.11", "91.210.164.5", "103.215.216.117", "103.215.216.116", "103.215.216.125", "103.215.216.197", "103.215.216.27", "103.215.216.75", "103.215.216.186", "103.215.216.162", "103.215.216.123", "149.104.90.200", "151.242.188.220", "180.149.44.43", "180.149.44.115", "194.213.18.178", "2.56.222.28", "2.56.222.49", "216.185.57.152", "217.69.13.77", "38.54.71.107", "38.54.71.56", "38.54.71.160", "45.80.208.195", "45.80.208.232", "45.80.208.66", "45.86.230.60", "45.90.58.202", "47.81.8.145", "89.223.91.91", "89.44.193.140", "160.16.83.208", "153.127.55.77", "134.255.211.224", "207.189.10.188", "91.227.77.172", "165.154.226.247", "165.154.243.24", "38.60.209.227", "216.238.118.179", "216.238.123.242", "64.190.113.170", "154.223.21.194", "154.205.154.82", "154.205.154.70", "37.122.150.133", "38.60.195.184", "103.9.77.116", "87.236.37.185", "92.118.127.23", "130.94.91.53", "45.39.103.5", "38.54.57.12", "38.54.45.155", "38.60.206.85", "38.60.209.65", "38.60.242.182", "38.60.241.65", "38.60.214.237", "149.104.87.222", "156.244.2.26", "149.104.12.128", "181.41.201.244", "38.60.241.193", "149.104.87.228", "77.111.101.153", "77.111.101.227", "77.111.101.11", "216.238.110.120", "216.238.71.215", "216.238.73.14", "216.238.111.30", "216.238.119.130", "216.238.90.160", "216.238.85.243", "216.238.107.140", "216.238.115.152", "64.176.10.7", "64.176.6.27", "45.76.215.17", "185.93.173.30", "188.214.157.51", "108.61.161.250", "167.179.109.141", "216.238.106.177", "216.238.113.122", "216.238.121.254", "216.238.120.8") BY All_Traffic.src_ip All_Traffic.dest_ip All_Traffic.dest_port All_Traffic.action All_Traffic.dvc All_Traffic.user | rename "All_Traffic.*" AS * | eval data_model="Network_Traffic", ioc_type="ipv4", ioc=src_ip, host=dvc, src=src_ip, dest=dest_ip, detail="connection from IOC, port ".dest_port.", ".action ] | append [ | 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 ("microsfot.vip", "*.microsfot.vip", "microscoft.vip", "*.microscoft.vip", "aistei.com", "*.aistei.com", "astorialaza.com", "*.astorialaza.com", "windowsdefender.it.com", "*.windowsdefender.it.com", "windowsupdates.us", "*.windowsupdates.us", "microupdate.me", "*.microupdate.me", "windefender.net", "*.windefender.net", "seosnskorea.com", "*.seosnskorea.com", "amelicen.com", "*.amelicen.com", "jamvybez.com", "*.jamvybez.com", "artfingo.com", "*.artfingo.com", "faceorkut.com", "*.faceorkut.com", "aauctioneer.com", "*.aauctioneer.com") BY DNS.src DNS.dest DNS.query DNS.reply_code | rename "DNS.*" AS * | rex field=query "(?i)(?(?:microsfot\.vip|microscoft\.vip|aistei\.com|astorialaza\.com|windowsdefender\.it\.com|windowsupdates\.us|microupdate\.me|windefender\.net|seosnskorea\.com|amelicen\.com|jamvybez\.com|artfingo\.com|faceorkut\.com|aauctioneer\.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 ("*://microsfot.vip*", "*.microsfot.vip*", "microsfot.vip*", "*://microscoft.vip*", "*.microscoft.vip*", "microscoft.vip*", "*://aistei.com*", "*.aistei.com*", "aistei.com*", "*://astorialaza.com*", "*.astorialaza.com*", "astorialaza.com*", "*://windowsdefender.it.com*", "*.windowsdefender.it.com*", "windowsdefender.it.com*", "*://windowsupdates.us*", "*.windowsupdates.us*", "windowsupdates.us*", "*://microupdate.me*", "*.microupdate.me*", "microupdate.me*", "*://windefender.net*", "*.windefender.net*", "windefender.net*", "*://seosnskorea.com*", "*.seosnskorea.com*", "seosnskorea.com*", "*://amelicen.com*", "*.amelicen.com*", "amelicen.com*", "*://jamvybez.com*", "*.jamvybez.com*", "jamvybez.com*", "*://artfingo.com*", "*.artfingo.com*", "artfingo.com*", "*://faceorkut.com*", "*.faceorkut.com*", "faceorkut.com*", "*://aauctioneer.com*", "*.aauctioneer.com*", "aauctioneer.com*") OR Web.dest IN ("microsfot.vip", "*.microsfot.vip", "microscoft.vip", "*.microscoft.vip", "aistei.com", "*.aistei.com", "astorialaza.com", "*.astorialaza.com", "windowsdefender.it.com", "*.windowsdefender.it.com", "windowsupdates.us", "*.windowsupdates.us", "microupdate.me", "*.microupdate.me", "windefender.net", "*.windefender.net", "seosnskorea.com", "*.seosnskorea.com", "amelicen.com", "*.amelicen.com", "jamvybez.com", "*.jamvybez.com", "artfingo.com", "*.artfingo.com", "faceorkut.com", "*.faceorkut.com", "aauctioneer.com", "*.aauctioneer.com")) BY Web.src Web.user Web.dest Web.url Web.http_user_agent Web.status | rename "Web.*" AS * | rex field=url "(?i)(?microsfot\.vip|microscoft\.vip|aistei\.com|astorialaza\.com|windowsdefender\.it\.com|windowsupdates\.us|microupdate\.me|windefender\.net|seosnskorea\.com|amelicen\.com|jamvybez\.com|artfingo\.com|faceorkut\.com|aauctioneer\.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 ("*715c206629f59ff5b0134a33362162ce7a40a9b25aa17f0543dc9648d51a67cf*", "*b379d07ba81d4190490d9893b2d6d830ff594e042dce26053ef07794d0403787*", "*e5f7bbfc187264336dea5dfebfb5a7dd1e7fcdcc9692db55fbe6eb4d28f027bc*", "*e9f2f42ea3611096879f4152a7d78bb3a78a4dbead1c3b7e366dce485207551f*", "*f44159bec1d4d3f340652cd3c6e250dcf2bdb266e5400d3e267f0466d290dda0*", "*f51dc5e1848daee4e607d46faa25033e1151060cd3482ad4439754440d6c4c01*", "*8bbc395a7a0faff074c6e31c7da37bf1540a4e7ec3d80870f8d6bd1f5d4cecbb*", "*054c0ffb08eb7830de1ff2356af4d2ed696f01111a8c2e78e3a4ddc940287e48*", "*b60404c1299e69df029d9817dcf69f9fe325ecc990e16bc7758f56ce5714184b*", "*f23e5391656b178bc0ab510b0fca6ffbd963cf94870c82a5920f0f338f561f18*", "*1cd0c608418cca80149ef3077e54969f24cd7ef3f22707cb280fa4b378ffa76b*", "*40880b6fce6f83df4e902cd29d7abb303ffa3f37c429c382f2aaeea34f7be074*", "*9fa421adb5c5dac3b2fc1165b0dddd596e82cfd3b08347a91d63f9e88d8718d0*", "*3637f4f804cffc3b25222d542e7cb544ee48074ed2e46607e31f9410c17bf223*", "*1b365975f9ad8a4748b2bbfb36de3be171aeadeb59d497192a8b4d9560b37173*", "*d1da8e2389f48d1d1c0e127f3417e3d3e0dbf54691e22d6d0c863d28b9e7a812*", "*dbdaa8a52246b1e3f9285820db2f976b8ab513926ed972c968fae1c8aeb77056*", "*46407cc35c48d19c6b1990a03ebdd19321005ce08d5a98acd168fda55a92d946*", "*3e4eef1a641d6060f6144ceba6757df6085d475eedb8b9e61b5feb84e9fb989e*", "*cc3544ac194a4ab5f3a60dbedd270192bc01afd2a365b3b136b35d40d8dd3ff0*", "*ea25b021f90dbd1c53cd3490274c5c92856d4f815d85f3ec68600facab2c952f*", "*fa28bc5dfc2c37c3104961f5ca80f590259a27743a8aa327c606fb51452b840f*", "*2ea96ea398e9254706ff2761b86302372c149ef090536ad76231e51d7c810a2a*", "*50daadd49b8df4f0190d0badfde89f8e6a6e61af664ef1444984028a005f40d8*", "*cbce7dc8649b37c5db411dfee3a74e8cace2b48fdc8350bfa5b4846c5d9ed2ae*", "*9d01724193d9570a6c75bbcbb171d29df290207007d004cf75d133dd9aa475f4*", "*129349a221e6efcc9a047efdfd81197f796fcf38877344f17f85651b21e33427*", "*4cafda69af3179ceb4a1f5ed864c501279796254709c86ca236be1cf74a8643f*", "*48dcc07d9f87129e937f5ca2ad5ba56975600efb8a7280a170b2aeeff503f595*", "*a47279e4ee703092263e7030c43c61533146c00689e7cb8f2080f18e57d5cf7f*", "*d4e4a3f55b875673cfdb6d0687cc3f8890585210806b03082d11fb4fa40b57de*", "*3317789219e9b3e48fbb8f7af23359a37539597fc4d84649086aec71a21553ee*", "*c049e5e03a04cf54f8aa089c65861342d3fb4aa8d6a2b1c9484637c46ddc3882*", "*f01a73f651f8113bf9672dbe4c50c63ed365a41e4187aaf0a5ab34cd21154046*", "*9332f9cd283d69e9a2a2bb71575054cc71c14b6496ac55f7ff43efdcb6d97a01*", "*12b6d5ca7aca7134032721b6feb8e4d5ad75c886fbf8a5889d3d36971a083681*", "*125525a38abc45e855f848d499582a8100f1428938d4bd3d3eba957072e64e7a*", "*4b1fea3265492ad1d272428447fb5919bbe3184131b12a0ae84caf3bc442718e*", "*4e50f53b5294a6dbd601fc20a607ae85725162b596119f4867311ef0b3f75a6a*", "*f42461c386834d61780da13760a130ed2ea620627b5eebf97b56237058ea380d*", "*b7060cf7955a1f1caac2bc3d0918c9b1d9daa315c5d82b329acd3bbddb413948*", "*cb714decdcabe30008546e6fb71bb28e390c9bd186bf2549aaa8fe5b999200a5*", "*de6a3140797f7c00a48b2068127965c3994f92867466259e69c861880e6ec2d8*", "*d08e09a17df22fb39838dcc9e99756830ef5175bc9e03d615adf979dc85ed052*", "*417664cc34360d8519adc7a019408cf8f37f59c95a44e50092d73e38b7889a21*", "*fd0861a8269f2bb2fe0adfb4b4610d9675e68474503598f83e87c29b88906f99*", "*916a16a4a1eb7393b17574835312725e5cb146995a3cbcdf42fa8b9bebaa51b1*", "*675a44c679dea8d40b3885c37168929f976e3a0ecacc7e02c6b07936ac58a9fc*", "*3a1b7ec461d656524e612b228ce969bfa612c799fb7117bb066352ff776d88da*", "*ee8c148518c5a416fc7d9b33246e9c98d955f2379aa9c82225e045322c97a043*", "*4f9d9a6cba88832fcb7cfb845472b63ff15cb9b417f4f02cb8086552c19ceffc*") 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)(?715c206629f59ff5b0134a33362162ce7a40a9b25aa17f0543dc9648d51a67cf|b379d07ba81d4190490d9893b2d6d830ff594e042dce26053ef07794d0403787|e5f7bbfc187264336dea5dfebfb5a7dd1e7fcdcc9692db55fbe6eb4d28f027bc|e9f2f42ea3611096879f4152a7d78bb3a78a4dbead1c3b7e366dce485207551f|f44159bec1d4d3f340652cd3c6e250dcf2bdb266e5400d3e267f0466d290dda0|f51dc5e1848daee4e607d46faa25033e1151060cd3482ad4439754440d6c4c01|8bbc395a7a0faff074c6e31c7da37bf1540a4e7ec3d80870f8d6bd1f5d4cecbb|054c0ffb08eb7830de1ff2356af4d2ed696f01111a8c2e78e3a4ddc940287e48|b60404c1299e69df029d9817dcf69f9fe325ecc990e16bc7758f56ce5714184b|f23e5391656b178bc0ab510b0fca6ffbd963cf94870c82a5920f0f338f561f18|1cd0c608418cca80149ef3077e54969f24cd7ef3f22707cb280fa4b378ffa76b|40880b6fce6f83df4e902cd29d7abb303ffa3f37c429c382f2aaeea34f7be074|9fa421adb5c5dac3b2fc1165b0dddd596e82cfd3b08347a91d63f9e88d8718d0|3637f4f804cffc3b25222d542e7cb544ee48074ed2e46607e31f9410c17bf223|1b365975f9ad8a4748b2bbfb36de3be171aeadeb59d497192a8b4d9560b37173|d1da8e2389f48d1d1c0e127f3417e3d3e0dbf54691e22d6d0c863d28b9e7a812|dbdaa8a52246b1e3f9285820db2f976b8ab513926ed972c968fae1c8aeb77056|46407cc35c48d19c6b1990a03ebdd19321005ce08d5a98acd168fda55a92d946|3e4eef1a641d6060f6144ceba6757df6085d475eedb8b9e61b5feb84e9fb989e|cc3544ac194a4ab5f3a60dbedd270192bc01afd2a365b3b136b35d40d8dd3ff0|ea25b021f90dbd1c53cd3490274c5c92856d4f815d85f3ec68600facab2c952f|fa28bc5dfc2c37c3104961f5ca80f590259a27743a8aa327c606fb51452b840f|2ea96ea398e9254706ff2761b86302372c149ef090536ad76231e51d7c810a2a|50daadd49b8df4f0190d0badfde89f8e6a6e61af664ef1444984028a005f40d8|cbce7dc8649b37c5db411dfee3a74e8cace2b48fdc8350bfa5b4846c5d9ed2ae|9d01724193d9570a6c75bbcbb171d29df290207007d004cf75d133dd9aa475f4|129349a221e6efcc9a047efdfd81197f796fcf38877344f17f85651b21e33427|4cafda69af3179ceb4a1f5ed864c501279796254709c86ca236be1cf74a8643f|48dcc07d9f87129e937f5ca2ad5ba56975600efb8a7280a170b2aeeff503f595|a47279e4ee703092263e7030c43c61533146c00689e7cb8f2080f18e57d5cf7f|d4e4a3f55b875673cfdb6d0687cc3f8890585210806b03082d11fb4fa40b57de|3317789219e9b3e48fbb8f7af23359a37539597fc4d84649086aec71a21553ee|c049e5e03a04cf54f8aa089c65861342d3fb4aa8d6a2b1c9484637c46ddc3882|f01a73f651f8113bf9672dbe4c50c63ed365a41e4187aaf0a5ab34cd21154046|9332f9cd283d69e9a2a2bb71575054cc71c14b6496ac55f7ff43efdcb6d97a01|12b6d5ca7aca7134032721b6feb8e4d5ad75c886fbf8a5889d3d36971a083681|125525a38abc45e855f848d499582a8100f1428938d4bd3d3eba957072e64e7a|4b1fea3265492ad1d272428447fb5919bbe3184131b12a0ae84caf3bc442718e|4e50f53b5294a6dbd601fc20a607ae85725162b596119f4867311ef0b3f75a6a|f42461c386834d61780da13760a130ed2ea620627b5eebf97b56237058ea380d|b7060cf7955a1f1caac2bc3d0918c9b1d9daa315c5d82b329acd3bbddb413948|cb714decdcabe30008546e6fb71bb28e390c9bd186bf2549aaa8fe5b999200a5|de6a3140797f7c00a48b2068127965c3994f92867466259e69c861880e6ec2d8|d08e09a17df22fb39838dcc9e99756830ef5175bc9e03d615adf979dc85ed052|417664cc34360d8519adc7a019408cf8f37f59c95a44e50092d73e38b7889a21|fd0861a8269f2bb2fe0adfb4b4610d9675e68474503598f83e87c29b88906f99|916a16a4a1eb7393b17574835312725e5cb146995a3cbcdf42fa8b9bebaa51b1|675a44c679dea8d40b3885c37168929f976e3a0ecacc7e02c6b07936ac58a9fc|3a1b7ec461d656524e612b228ce969bfa612c799fb7117bb066352ff776d88da|ee8c148518c5a416fc7d9b33246e9c98d955f2379aa9c82225e045322c97a043|4f9d9a6cba88832fcb7cfb845472b63ff15cb9b417f4f02cb8086552c19ceffc)" | 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 ("*715c206629f59ff5b0134a33362162ce7a40a9b25aa17f0543dc9648d51a67cf*", "*b379d07ba81d4190490d9893b2d6d830ff594e042dce26053ef07794d0403787*", "*e5f7bbfc187264336dea5dfebfb5a7dd1e7fcdcc9692db55fbe6eb4d28f027bc*", "*e9f2f42ea3611096879f4152a7d78bb3a78a4dbead1c3b7e366dce485207551f*", "*f44159bec1d4d3f340652cd3c6e250dcf2bdb266e5400d3e267f0466d290dda0*", "*f51dc5e1848daee4e607d46faa25033e1151060cd3482ad4439754440d6c4c01*", "*8bbc395a7a0faff074c6e31c7da37bf1540a4e7ec3d80870f8d6bd1f5d4cecbb*", "*054c0ffb08eb7830de1ff2356af4d2ed696f01111a8c2e78e3a4ddc940287e48*", "*b60404c1299e69df029d9817dcf69f9fe325ecc990e16bc7758f56ce5714184b*", "*f23e5391656b178bc0ab510b0fca6ffbd963cf94870c82a5920f0f338f561f18*", "*1cd0c608418cca80149ef3077e54969f24cd7ef3f22707cb280fa4b378ffa76b*", "*40880b6fce6f83df4e902cd29d7abb303ffa3f37c429c382f2aaeea34f7be074*", "*9fa421adb5c5dac3b2fc1165b0dddd596e82cfd3b08347a91d63f9e88d8718d0*", "*3637f4f804cffc3b25222d542e7cb544ee48074ed2e46607e31f9410c17bf223*", "*1b365975f9ad8a4748b2bbfb36de3be171aeadeb59d497192a8b4d9560b37173*", "*d1da8e2389f48d1d1c0e127f3417e3d3e0dbf54691e22d6d0c863d28b9e7a812*", "*dbdaa8a52246b1e3f9285820db2f976b8ab513926ed972c968fae1c8aeb77056*", "*46407cc35c48d19c6b1990a03ebdd19321005ce08d5a98acd168fda55a92d946*", "*3e4eef1a641d6060f6144ceba6757df6085d475eedb8b9e61b5feb84e9fb989e*", "*cc3544ac194a4ab5f3a60dbedd270192bc01afd2a365b3b136b35d40d8dd3ff0*", "*ea25b021f90dbd1c53cd3490274c5c92856d4f815d85f3ec68600facab2c952f*", "*fa28bc5dfc2c37c3104961f5ca80f590259a27743a8aa327c606fb51452b840f*", "*2ea96ea398e9254706ff2761b86302372c149ef090536ad76231e51d7c810a2a*", "*50daadd49b8df4f0190d0badfde89f8e6a6e61af664ef1444984028a005f40d8*", "*cbce7dc8649b37c5db411dfee3a74e8cace2b48fdc8350bfa5b4846c5d9ed2ae*", "*9d01724193d9570a6c75bbcbb171d29df290207007d004cf75d133dd9aa475f4*", "*129349a221e6efcc9a047efdfd81197f796fcf38877344f17f85651b21e33427*", "*4cafda69af3179ceb4a1f5ed864c501279796254709c86ca236be1cf74a8643f*", "*48dcc07d9f87129e937f5ca2ad5ba56975600efb8a7280a170b2aeeff503f595*", "*a47279e4ee703092263e7030c43c61533146c00689e7cb8f2080f18e57d5cf7f*", "*d4e4a3f55b875673cfdb6d0687cc3f8890585210806b03082d11fb4fa40b57de*", "*3317789219e9b3e48fbb8f7af23359a37539597fc4d84649086aec71a21553ee*", "*c049e5e03a04cf54f8aa089c65861342d3fb4aa8d6a2b1c9484637c46ddc3882*", "*f01a73f651f8113bf9672dbe4c50c63ed365a41e4187aaf0a5ab34cd21154046*", "*9332f9cd283d69e9a2a2bb71575054cc71c14b6496ac55f7ff43efdcb6d97a01*", "*12b6d5ca7aca7134032721b6feb8e4d5ad75c886fbf8a5889d3d36971a083681*", "*125525a38abc45e855f848d499582a8100f1428938d4bd3d3eba957072e64e7a*", "*4b1fea3265492ad1d272428447fb5919bbe3184131b12a0ae84caf3bc442718e*", "*4e50f53b5294a6dbd601fc20a607ae85725162b596119f4867311ef0b3f75a6a*", "*f42461c386834d61780da13760a130ed2ea620627b5eebf97b56237058ea380d*", "*b7060cf7955a1f1caac2bc3d0918c9b1d9daa315c5d82b329acd3bbddb413948*", "*cb714decdcabe30008546e6fb71bb28e390c9bd186bf2549aaa8fe5b999200a5*", "*de6a3140797f7c00a48b2068127965c3994f92867466259e69c861880e6ec2d8*", "*d08e09a17df22fb39838dcc9e99756830ef5175bc9e03d615adf979dc85ed052*", "*417664cc34360d8519adc7a019408cf8f37f59c95a44e50092d73e38b7889a21*", "*fd0861a8269f2bb2fe0adfb4b4610d9675e68474503598f83e87c29b88906f99*", "*916a16a4a1eb7393b17574835312725e5cb146995a3cbcdf42fa8b9bebaa51b1*", "*675a44c679dea8d40b3885c37168929f976e3a0ecacc7e02c6b07936ac58a9fc*", "*3a1b7ec461d656524e612b228ce969bfa612c799fb7117bb066352ff776d88da*", "*ee8c148518c5a416fc7d9b33246e9c98d955f2379aa9c82225e045322c97a043*", "*4f9d9a6cba88832fcb7cfb845472b63ff15cb9b417f4f02cb8086552c19ceffc*") 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)(?715c206629f59ff5b0134a33362162ce7a40a9b25aa17f0543dc9648d51a67cf|b379d07ba81d4190490d9893b2d6d830ff594e042dce26053ef07794d0403787|e5f7bbfc187264336dea5dfebfb5a7dd1e7fcdcc9692db55fbe6eb4d28f027bc|e9f2f42ea3611096879f4152a7d78bb3a78a4dbead1c3b7e366dce485207551f|f44159bec1d4d3f340652cd3c6e250dcf2bdb266e5400d3e267f0466d290dda0|f51dc5e1848daee4e607d46faa25033e1151060cd3482ad4439754440d6c4c01|8bbc395a7a0faff074c6e31c7da37bf1540a4e7ec3d80870f8d6bd1f5d4cecbb|054c0ffb08eb7830de1ff2356af4d2ed696f01111a8c2e78e3a4ddc940287e48|b60404c1299e69df029d9817dcf69f9fe325ecc990e16bc7758f56ce5714184b|f23e5391656b178bc0ab510b0fca6ffbd963cf94870c82a5920f0f338f561f18|1cd0c608418cca80149ef3077e54969f24cd7ef3f22707cb280fa4b378ffa76b|40880b6fce6f83df4e902cd29d7abb303ffa3f37c429c382f2aaeea34f7be074|9fa421adb5c5dac3b2fc1165b0dddd596e82cfd3b08347a91d63f9e88d8718d0|3637f4f804cffc3b25222d542e7cb544ee48074ed2e46607e31f9410c17bf223|1b365975f9ad8a4748b2bbfb36de3be171aeadeb59d497192a8b4d9560b37173|d1da8e2389f48d1d1c0e127f3417e3d3e0dbf54691e22d6d0c863d28b9e7a812|dbdaa8a52246b1e3f9285820db2f976b8ab513926ed972c968fae1c8aeb77056|46407cc35c48d19c6b1990a03ebdd19321005ce08d5a98acd168fda55a92d946|3e4eef1a641d6060f6144ceba6757df6085d475eedb8b9e61b5feb84e9fb989e|cc3544ac194a4ab5f3a60dbedd270192bc01afd2a365b3b136b35d40d8dd3ff0|ea25b021f90dbd1c53cd3490274c5c92856d4f815d85f3ec68600facab2c952f|fa28bc5dfc2c37c3104961f5ca80f590259a27743a8aa327c606fb51452b840f|2ea96ea398e9254706ff2761b86302372c149ef090536ad76231e51d7c810a2a|50daadd49b8df4f0190d0badfde89f8e6a6e61af664ef1444984028a005f40d8|cbce7dc8649b37c5db411dfee3a74e8cace2b48fdc8350bfa5b4846c5d9ed2ae|9d01724193d9570a6c75bbcbb171d29df290207007d004cf75d133dd9aa475f4|129349a221e6efcc9a047efdfd81197f796fcf38877344f17f85651b21e33427|4cafda69af3179ceb4a1f5ed864c501279796254709c86ca236be1cf74a8643f|48dcc07d9f87129e937f5ca2ad5ba56975600efb8a7280a170b2aeeff503f595|a47279e4ee703092263e7030c43c61533146c00689e7cb8f2080f18e57d5cf7f|d4e4a3f55b875673cfdb6d0687cc3f8890585210806b03082d11fb4fa40b57de|3317789219e9b3e48fbb8f7af23359a37539597fc4d84649086aec71a21553ee|c049e5e03a04cf54f8aa089c65861342d3fb4aa8d6a2b1c9484637c46ddc3882|f01a73f651f8113bf9672dbe4c50c63ed365a41e4187aaf0a5ab34cd21154046|9332f9cd283d69e9a2a2bb71575054cc71c14b6496ac55f7ff43efdcb6d97a01|12b6d5ca7aca7134032721b6feb8e4d5ad75c886fbf8a5889d3d36971a083681|125525a38abc45e855f848d499582a8100f1428938d4bd3d3eba957072e64e7a|4b1fea3265492ad1d272428447fb5919bbe3184131b12a0ae84caf3bc442718e|4e50f53b5294a6dbd601fc20a607ae85725162b596119f4867311ef0b3f75a6a|f42461c386834d61780da13760a130ed2ea620627b5eebf97b56237058ea380d|b7060cf7955a1f1caac2bc3d0918c9b1d9daa315c5d82b329acd3bbddb413948|cb714decdcabe30008546e6fb71bb28e390c9bd186bf2549aaa8fe5b999200a5|de6a3140797f7c00a48b2068127965c3994f92867466259e69c861880e6ec2d8|d08e09a17df22fb39838dcc9e99756830ef5175bc9e03d615adf979dc85ed052|417664cc34360d8519adc7a019408cf8f37f59c95a44e50092d73e38b7889a21|fd0861a8269f2bb2fe0adfb4b4610d9675e68474503598f83e87c29b88906f99|916a16a4a1eb7393b17574835312725e5cb146995a3cbcdf42fa8b9bebaa51b1|675a44c679dea8d40b3885c37168929f976e3a0ecacc7e02c6b07936ac58a9fc|3a1b7ec461d656524e612b228ce969bfa612c799fb7117bb066352ff776d88da|ee8c148518c5a416fc7d9b33246e9c98d955f2379aa9c82225e045322c97a043|4f9d9a6cba88832fcb7cfb845472b63ff15cb9b417f4f02cb8086552c19ceffc)" | 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 ("*715c206629f59ff5b0134a33362162ce7a40a9b25aa17f0543dc9648d51a67cf*", "*b379d07ba81d4190490d9893b2d6d830ff594e042dce26053ef07794d0403787*", "*e5f7bbfc187264336dea5dfebfb5a7dd1e7fcdcc9692db55fbe6eb4d28f027bc*", "*e9f2f42ea3611096879f4152a7d78bb3a78a4dbead1c3b7e366dce485207551f*", "*f44159bec1d4d3f340652cd3c6e250dcf2bdb266e5400d3e267f0466d290dda0*", "*f51dc5e1848daee4e607d46faa25033e1151060cd3482ad4439754440d6c4c01*", "*8bbc395a7a0faff074c6e31c7da37bf1540a4e7ec3d80870f8d6bd1f5d4cecbb*", "*054c0ffb08eb7830de1ff2356af4d2ed696f01111a8c2e78e3a4ddc940287e48*", "*b60404c1299e69df029d9817dcf69f9fe325ecc990e16bc7758f56ce5714184b*", "*f23e5391656b178bc0ab510b0fca6ffbd963cf94870c82a5920f0f338f561f18*", "*1cd0c608418cca80149ef3077e54969f24cd7ef3f22707cb280fa4b378ffa76b*", "*40880b6fce6f83df4e902cd29d7abb303ffa3f37c429c382f2aaeea34f7be074*", "*9fa421adb5c5dac3b2fc1165b0dddd596e82cfd3b08347a91d63f9e88d8718d0*", "*3637f4f804cffc3b25222d542e7cb544ee48074ed2e46607e31f9410c17bf223*", "*1b365975f9ad8a4748b2bbfb36de3be171aeadeb59d497192a8b4d9560b37173*", "*d1da8e2389f48d1d1c0e127f3417e3d3e0dbf54691e22d6d0c863d28b9e7a812*", "*dbdaa8a52246b1e3f9285820db2f976b8ab513926ed972c968fae1c8aeb77056*", "*46407cc35c48d19c6b1990a03ebdd19321005ce08d5a98acd168fda55a92d946*", "*3e4eef1a641d6060f6144ceba6757df6085d475eedb8b9e61b5feb84e9fb989e*", "*cc3544ac194a4ab5f3a60dbedd270192bc01afd2a365b3b136b35d40d8dd3ff0*", "*ea25b021f90dbd1c53cd3490274c5c92856d4f815d85f3ec68600facab2c952f*", "*fa28bc5dfc2c37c3104961f5ca80f590259a27743a8aa327c606fb51452b840f*", "*2ea96ea398e9254706ff2761b86302372c149ef090536ad76231e51d7c810a2a*", "*50daadd49b8df4f0190d0badfde89f8e6a6e61af664ef1444984028a005f40d8*", "*cbce7dc8649b37c5db411dfee3a74e8cace2b48fdc8350bfa5b4846c5d9ed2ae*", "*9d01724193d9570a6c75bbcbb171d29df290207007d004cf75d133dd9aa475f4*", "*129349a221e6efcc9a047efdfd81197f796fcf38877344f17f85651b21e33427*", "*4cafda69af3179ceb4a1f5ed864c501279796254709c86ca236be1cf74a8643f*", "*48dcc07d9f87129e937f5ca2ad5ba56975600efb8a7280a170b2aeeff503f595*", "*a47279e4ee703092263e7030c43c61533146c00689e7cb8f2080f18e57d5cf7f*", "*d4e4a3f55b875673cfdb6d0687cc3f8890585210806b03082d11fb4fa40b57de*", "*3317789219e9b3e48fbb8f7af23359a37539597fc4d84649086aec71a21553ee*", "*c049e5e03a04cf54f8aa089c65861342d3fb4aa8d6a2b1c9484637c46ddc3882*", "*f01a73f651f8113bf9672dbe4c50c63ed365a41e4187aaf0a5ab34cd21154046*", "*9332f9cd283d69e9a2a2bb71575054cc71c14b6496ac55f7ff43efdcb6d97a01*", "*12b6d5ca7aca7134032721b6feb8e4d5ad75c886fbf8a5889d3d36971a083681*", "*125525a38abc45e855f848d499582a8100f1428938d4bd3d3eba957072e64e7a*", "*4b1fea3265492ad1d272428447fb5919bbe3184131b12a0ae84caf3bc442718e*", "*4e50f53b5294a6dbd601fc20a607ae85725162b596119f4867311ef0b3f75a6a*", "*f42461c386834d61780da13760a130ed2ea620627b5eebf97b56237058ea380d*", "*b7060cf7955a1f1caac2bc3d0918c9b1d9daa315c5d82b329acd3bbddb413948*", "*cb714decdcabe30008546e6fb71bb28e390c9bd186bf2549aaa8fe5b999200a5*", "*de6a3140797f7c00a48b2068127965c3994f92867466259e69c861880e6ec2d8*", "*d08e09a17df22fb39838dcc9e99756830ef5175bc9e03d615adf979dc85ed052*", "*417664cc34360d8519adc7a019408cf8f37f59c95a44e50092d73e38b7889a21*", "*fd0861a8269f2bb2fe0adfb4b4610d9675e68474503598f83e87c29b88906f99*", "*916a16a4a1eb7393b17574835312725e5cb146995a3cbcdf42fa8b9bebaa51b1*", "*675a44c679dea8d40b3885c37168929f976e3a0ecacc7e02c6b07936ac58a9fc*", "*3a1b7ec461d656524e612b228ce969bfa612c799fb7117bb066352ff776d88da*", "*ee8c148518c5a416fc7d9b33246e9c98d955f2379aa9c82225e045322c97a043*", "*4f9d9a6cba88832fcb7cfb845472b63ff15cb9b417f4f02cb8086552c19ceffc*") BY Filesystem.dest Filesystem.user Filesystem.file_path Filesystem.file_name Filesystem.action Filesystem.file_hash | rename "Filesystem.*" AS * | rex field=file_hash "(?i)(?715c206629f59ff5b0134a33362162ce7a40a9b25aa17f0543dc9648d51a67cf|b379d07ba81d4190490d9893b2d6d830ff594e042dce26053ef07794d0403787|e5f7bbfc187264336dea5dfebfb5a7dd1e7fcdcc9692db55fbe6eb4d28f027bc|e9f2f42ea3611096879f4152a7d78bb3a78a4dbead1c3b7e366dce485207551f|f44159bec1d4d3f340652cd3c6e250dcf2bdb266e5400d3e267f0466d290dda0|f51dc5e1848daee4e607d46faa25033e1151060cd3482ad4439754440d6c4c01|8bbc395a7a0faff074c6e31c7da37bf1540a4e7ec3d80870f8d6bd1f5d4cecbb|054c0ffb08eb7830de1ff2356af4d2ed696f01111a8c2e78e3a4ddc940287e48|b60404c1299e69df029d9817dcf69f9fe325ecc990e16bc7758f56ce5714184b|f23e5391656b178bc0ab510b0fca6ffbd963cf94870c82a5920f0f338f561f18|1cd0c608418cca80149ef3077e54969f24cd7ef3f22707cb280fa4b378ffa76b|40880b6fce6f83df4e902cd29d7abb303ffa3f37c429c382f2aaeea34f7be074|9fa421adb5c5dac3b2fc1165b0dddd596e82cfd3b08347a91d63f9e88d8718d0|3637f4f804cffc3b25222d542e7cb544ee48074ed2e46607e31f9410c17bf223|1b365975f9ad8a4748b2bbfb36de3be171aeadeb59d497192a8b4d9560b37173|d1da8e2389f48d1d1c0e127f3417e3d3e0dbf54691e22d6d0c863d28b9e7a812|dbdaa8a52246b1e3f9285820db2f976b8ab513926ed972c968fae1c8aeb77056|46407cc35c48d19c6b1990a03ebdd19321005ce08d5a98acd168fda55a92d946|3e4eef1a641d6060f6144ceba6757df6085d475eedb8b9e61b5feb84e9fb989e|cc3544ac194a4ab5f3a60dbedd270192bc01afd2a365b3b136b35d40d8dd3ff0|ea25b021f90dbd1c53cd3490274c5c92856d4f815d85f3ec68600facab2c952f|fa28bc5dfc2c37c3104961f5ca80f590259a27743a8aa327c606fb51452b840f|2ea96ea398e9254706ff2761b86302372c149ef090536ad76231e51d7c810a2a|50daadd49b8df4f0190d0badfde89f8e6a6e61af664ef1444984028a005f40d8|cbce7dc8649b37c5db411dfee3a74e8cace2b48fdc8350bfa5b4846c5d9ed2ae|9d01724193d9570a6c75bbcbb171d29df290207007d004cf75d133dd9aa475f4|129349a221e6efcc9a047efdfd81197f796fcf38877344f17f85651b21e33427|4cafda69af3179ceb4a1f5ed864c501279796254709c86ca236be1cf74a8643f|48dcc07d9f87129e937f5ca2ad5ba56975600efb8a7280a170b2aeeff503f595|a47279e4ee703092263e7030c43c61533146c00689e7cb8f2080f18e57d5cf7f|d4e4a3f55b875673cfdb6d0687cc3f8890585210806b03082d11fb4fa40b57de|3317789219e9b3e48fbb8f7af23359a37539597fc4d84649086aec71a21553ee|c049e5e03a04cf54f8aa089c65861342d3fb4aa8d6a2b1c9484637c46ddc3882|f01a73f651f8113bf9672dbe4c50c63ed365a41e4187aaf0a5ab34cd21154046|9332f9cd283d69e9a2a2bb71575054cc71c14b6496ac55f7ff43efdcb6d97a01|12b6d5ca7aca7134032721b6feb8e4d5ad75c886fbf8a5889d3d36971a083681|125525a38abc45e855f848d499582a8100f1428938d4bd3d3eba957072e64e7a|4b1fea3265492ad1d272428447fb5919bbe3184131b12a0ae84caf3bc442718e|4e50f53b5294a6dbd601fc20a607ae85725162b596119f4867311ef0b3f75a6a|f42461c386834d61780da13760a130ed2ea620627b5eebf97b56237058ea380d|b7060cf7955a1f1caac2bc3d0918c9b1d9daa315c5d82b329acd3bbddb413948|cb714decdcabe30008546e6fb71bb28e390c9bd186bf2549aaa8fe5b999200a5|de6a3140797f7c00a48b2068127965c3994f92867466259e69c861880e6ec2d8|d08e09a17df22fb39838dcc9e99756830ef5175bc9e03d615adf979dc85ed052|417664cc34360d8519adc7a019408cf8f37f59c95a44e50092d73e38b7889a21|fd0861a8269f2bb2fe0adfb4b4610d9675e68474503598f83e87c29b88906f99|916a16a4a1eb7393b17574835312725e5cb146995a3cbcdf42fa8b9bebaa51b1|675a44c679dea8d40b3885c37168929f976e3a0ecacc7e02c6b07936ac58a9fc|3a1b7ec461d656524e612b228ce969bfa612c799fb7117bb066352ff776d88da|ee8c148518c5a416fc7d9b33246e9c98d955f2379aa9c82225e045322c97a043|4f9d9a6cba88832fcb7cfb845472b63ff15cb9b417f4f02cb8086552c19ceffc)" | 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 ("*715c206629f59ff5b0134a33362162ce7a40a9b25aa17f0543dc9648d51a67cf*", "*b379d07ba81d4190490d9893b2d6d830ff594e042dce26053ef07794d0403787*", "*e5f7bbfc187264336dea5dfebfb5a7dd1e7fcdcc9692db55fbe6eb4d28f027bc*", "*e9f2f42ea3611096879f4152a7d78bb3a78a4dbead1c3b7e366dce485207551f*", "*f44159bec1d4d3f340652cd3c6e250dcf2bdb266e5400d3e267f0466d290dda0*", "*f51dc5e1848daee4e607d46faa25033e1151060cd3482ad4439754440d6c4c01*", "*8bbc395a7a0faff074c6e31c7da37bf1540a4e7ec3d80870f8d6bd1f5d4cecbb*", "*054c0ffb08eb7830de1ff2356af4d2ed696f01111a8c2e78e3a4ddc940287e48*", "*b60404c1299e69df029d9817dcf69f9fe325ecc990e16bc7758f56ce5714184b*", "*f23e5391656b178bc0ab510b0fca6ffbd963cf94870c82a5920f0f338f561f18*", "*1cd0c608418cca80149ef3077e54969f24cd7ef3f22707cb280fa4b378ffa76b*", "*40880b6fce6f83df4e902cd29d7abb303ffa3f37c429c382f2aaeea34f7be074*", "*9fa421adb5c5dac3b2fc1165b0dddd596e82cfd3b08347a91d63f9e88d8718d0*", "*3637f4f804cffc3b25222d542e7cb544ee48074ed2e46607e31f9410c17bf223*", "*1b365975f9ad8a4748b2bbfb36de3be171aeadeb59d497192a8b4d9560b37173*", "*d1da8e2389f48d1d1c0e127f3417e3d3e0dbf54691e22d6d0c863d28b9e7a812*", "*dbdaa8a52246b1e3f9285820db2f976b8ab513926ed972c968fae1c8aeb77056*", "*46407cc35c48d19c6b1990a03ebdd19321005ce08d5a98acd168fda55a92d946*", "*3e4eef1a641d6060f6144ceba6757df6085d475eedb8b9e61b5feb84e9fb989e*", "*cc3544ac194a4ab5f3a60dbedd270192bc01afd2a365b3b136b35d40d8dd3ff0*", "*ea25b021f90dbd1c53cd3490274c5c92856d4f815d85f3ec68600facab2c952f*", "*fa28bc5dfc2c37c3104961f5ca80f590259a27743a8aa327c606fb51452b840f*", "*2ea96ea398e9254706ff2761b86302372c149ef090536ad76231e51d7c810a2a*", "*50daadd49b8df4f0190d0badfde89f8e6a6e61af664ef1444984028a005f40d8*", "*cbce7dc8649b37c5db411dfee3a74e8cace2b48fdc8350bfa5b4846c5d9ed2ae*", "*9d01724193d9570a6c75bbcbb171d29df290207007d004cf75d133dd9aa475f4*", "*129349a221e6efcc9a047efdfd81197f796fcf38877344f17f85651b21e33427*", "*4cafda69af3179ceb4a1f5ed864c501279796254709c86ca236be1cf74a8643f*", "*48dcc07d9f87129e937f5ca2ad5ba56975600efb8a7280a170b2aeeff503f595*", "*a47279e4ee703092263e7030c43c61533146c00689e7cb8f2080f18e57d5cf7f*", "*d4e4a3f55b875673cfdb6d0687cc3f8890585210806b03082d11fb4fa40b57de*", "*3317789219e9b3e48fbb8f7af23359a37539597fc4d84649086aec71a21553ee*", "*c049e5e03a04cf54f8aa089c65861342d3fb4aa8d6a2b1c9484637c46ddc3882*", "*f01a73f651f8113bf9672dbe4c50c63ed365a41e4187aaf0a5ab34cd21154046*", "*9332f9cd283d69e9a2a2bb71575054cc71c14b6496ac55f7ff43efdcb6d97a01*", "*12b6d5ca7aca7134032721b6feb8e4d5ad75c886fbf8a5889d3d36971a083681*", "*125525a38abc45e855f848d499582a8100f1428938d4bd3d3eba957072e64e7a*", "*4b1fea3265492ad1d272428447fb5919bbe3184131b12a0ae84caf3bc442718e*", "*4e50f53b5294a6dbd601fc20a607ae85725162b596119f4867311ef0b3f75a6a*", "*f42461c386834d61780da13760a130ed2ea620627b5eebf97b56237058ea380d*", "*b7060cf7955a1f1caac2bc3d0918c9b1d9daa315c5d82b329acd3bbddb413948*", "*cb714decdcabe30008546e6fb71bb28e390c9bd186bf2549aaa8fe5b999200a5*", "*de6a3140797f7c00a48b2068127965c3994f92867466259e69c861880e6ec2d8*", "*d08e09a17df22fb39838dcc9e99756830ef5175bc9e03d615adf979dc85ed052*", "*417664cc34360d8519adc7a019408cf8f37f59c95a44e50092d73e38b7889a21*", "*fd0861a8269f2bb2fe0adfb4b4610d9675e68474503598f83e87c29b88906f99*", "*916a16a4a1eb7393b17574835312725e5cb146995a3cbcdf42fa8b9bebaa51b1*", "*675a44c679dea8d40b3885c37168929f976e3a0ecacc7e02c6b07936ac58a9fc*", "*3a1b7ec461d656524e612b228ce969bfa612c799fb7117bb066352ff776d88da*", "*ee8c148518c5a416fc7d9b33246e9c98d955f2379aa9c82225e045322c97a043*", "*4f9d9a6cba88832fcb7cfb845472b63ff15cb9b417f4f02cb8086552c19ceffc*") OR All_Email.url IN ("*://microsfot.vip*", "*.microsfot.vip*", "microsfot.vip*", "*://microscoft.vip*", "*.microscoft.vip*", "microscoft.vip*", "*://aistei.com*", "*.aistei.com*", "aistei.com*", "*://astorialaza.com*", "*.astorialaza.com*", "astorialaza.com*", "*://windowsdefender.it.com*", "*.windowsdefender.it.com*", "windowsdefender.it.com*", "*://windowsupdates.us*", "*.windowsupdates.us*", "windowsupdates.us*", "*://microupdate.me*", "*.microupdate.me*", "microupdate.me*", "*://windefender.net*", "*.windefender.net*", "windefender.net*", "*://seosnskorea.com*", "*.seosnskorea.com*", "seosnskorea.com*", "*://amelicen.com*", "*.amelicen.com*", "amelicen.com*", "*://jamvybez.com*", "*.jamvybez.com*", "jamvybez.com*", "*://artfingo.com*", "*.artfingo.com*", "artfingo.com*", "*://faceorkut.com*", "*.faceorkut.com*", "faceorkut.com*", "*://aauctioneer.com*", "*.aauctioneer.com*", "aauctioneer.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)(?715c206629f59ff5b0134a33362162ce7a40a9b25aa17f0543dc9648d51a67cf|b379d07ba81d4190490d9893b2d6d830ff594e042dce26053ef07794d0403787|e5f7bbfc187264336dea5dfebfb5a7dd1e7fcdcc9692db55fbe6eb4d28f027bc|e9f2f42ea3611096879f4152a7d78bb3a78a4dbead1c3b7e366dce485207551f|f44159bec1d4d3f340652cd3c6e250dcf2bdb266e5400d3e267f0466d290dda0|f51dc5e1848daee4e607d46faa25033e1151060cd3482ad4439754440d6c4c01|8bbc395a7a0faff074c6e31c7da37bf1540a4e7ec3d80870f8d6bd1f5d4cecbb|054c0ffb08eb7830de1ff2356af4d2ed696f01111a8c2e78e3a4ddc940287e48|b60404c1299e69df029d9817dcf69f9fe325ecc990e16bc7758f56ce5714184b|f23e5391656b178bc0ab510b0fca6ffbd963cf94870c82a5920f0f338f561f18|1cd0c608418cca80149ef3077e54969f24cd7ef3f22707cb280fa4b378ffa76b|40880b6fce6f83df4e902cd29d7abb303ffa3f37c429c382f2aaeea34f7be074|9fa421adb5c5dac3b2fc1165b0dddd596e82cfd3b08347a91d63f9e88d8718d0|3637f4f804cffc3b25222d542e7cb544ee48074ed2e46607e31f9410c17bf223|1b365975f9ad8a4748b2bbfb36de3be171aeadeb59d497192a8b4d9560b37173|d1da8e2389f48d1d1c0e127f3417e3d3e0dbf54691e22d6d0c863d28b9e7a812|dbdaa8a52246b1e3f9285820db2f976b8ab513926ed972c968fae1c8aeb77056|46407cc35c48d19c6b1990a03ebdd19321005ce08d5a98acd168fda55a92d946|3e4eef1a641d6060f6144ceba6757df6085d475eedb8b9e61b5feb84e9fb989e|cc3544ac194a4ab5f3a60dbedd270192bc01afd2a365b3b136b35d40d8dd3ff0|ea25b021f90dbd1c53cd3490274c5c92856d4f815d85f3ec68600facab2c952f|fa28bc5dfc2c37c3104961f5ca80f590259a27743a8aa327c606fb51452b840f|2ea96ea398e9254706ff2761b86302372c149ef090536ad76231e51d7c810a2a|50daadd49b8df4f0190d0badfde89f8e6a6e61af664ef1444984028a005f40d8|cbce7dc8649b37c5db411dfee3a74e8cace2b48fdc8350bfa5b4846c5d9ed2ae|9d01724193d9570a6c75bbcbb171d29df290207007d004cf75d133dd9aa475f4|129349a221e6efcc9a047efdfd81197f796fcf38877344f17f85651b21e33427|4cafda69af3179ceb4a1f5ed864c501279796254709c86ca236be1cf74a8643f|48dcc07d9f87129e937f5ca2ad5ba56975600efb8a7280a170b2aeeff503f595|a47279e4ee703092263e7030c43c61533146c00689e7cb8f2080f18e57d5cf7f|d4e4a3f55b875673cfdb6d0687cc3f8890585210806b03082d11fb4fa40b57de|3317789219e9b3e48fbb8f7af23359a37539597fc4d84649086aec71a21553ee|c049e5e03a04cf54f8aa089c65861342d3fb4aa8d6a2b1c9484637c46ddc3882|f01a73f651f8113bf9672dbe4c50c63ed365a41e4187aaf0a5ab34cd21154046|9332f9cd283d69e9a2a2bb71575054cc71c14b6496ac55f7ff43efdcb6d97a01|12b6d5ca7aca7134032721b6feb8e4d5ad75c886fbf8a5889d3d36971a083681|125525a38abc45e855f848d499582a8100f1428938d4bd3d3eba957072e64e7a|4b1fea3265492ad1d272428447fb5919bbe3184131b12a0ae84caf3bc442718e|4e50f53b5294a6dbd601fc20a607ae85725162b596119f4867311ef0b3f75a6a|f42461c386834d61780da13760a130ed2ea620627b5eebf97b56237058ea380d|b7060cf7955a1f1caac2bc3d0918c9b1d9daa315c5d82b329acd3bbddb413948|cb714decdcabe30008546e6fb71bb28e390c9bd186bf2549aaa8fe5b999200a5|de6a3140797f7c00a48b2068127965c3994f92867466259e69c861880e6ec2d8|d08e09a17df22fb39838dcc9e99756830ef5175bc9e03d615adf979dc85ed052|417664cc34360d8519adc7a019408cf8f37f59c95a44e50092d73e38b7889a21|fd0861a8269f2bb2fe0adfb4b4610d9675e68474503598f83e87c29b88906f99|916a16a4a1eb7393b17574835312725e5cb146995a3cbcdf42fa8b9bebaa51b1|675a44c679dea8d40b3885c37168929f976e3a0ecacc7e02c6b07936ac58a9fc|3a1b7ec461d656524e612b228ce969bfa612c799fb7117bb066352ff776d88da|ee8c148518c5a416fc7d9b33246e9c98d955f2379aa9c82225e045322c97a043|4f9d9a6cba88832fcb7cfb845472b63ff15cb9b417f4f02cb8086552c19ceffc|microsfot\.vip|microscoft\.vip|aistei\.com|astorialaza\.com|windowsdefender\.it\.com|windowsupdates\.us|microupdate\.me|windefender\.net|seosnskorea\.com|amelicen\.com|jamvybez\.com|artfingo\.com|faceorkut\.com|aauctioneer\.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