Fraud ring detayı
ip:192.0.2.150
HIGH risk
Paylaşılan IP
5 müşteri
37 toplam sipariş
Müşteriler (5)
| Müşteri | Şehir | Sipariş |
|---|---|---|
| Berna Aslan #18 | İzmir | 9 |
| Burak Erdoğan #10 | Ankara | 6 |
| Defne Akkaya #42 | Antalya | 8 |
| Melike Doğan #30 | İstanbul | 6 |
| Sevgi Türk #22 | Antalya | 8 |
Bağlı cihazlar (5)
bbbbbbbbbbbb… · 192.0.2.150cccccccccccc… · 192.0.2.150dddddddddddd… · 192.0.2.150eeeeeeeeeeee… · 192.0.2.150ffffffffffff… · 192.0.2.150
T-SQL evidence (workshop)
-- Paylaşılan IP — SHORTEST_PATH ile evidence chain
SELECT *
FROM (
SELECT cn1.display_name AS start_customer,
LAST_VALUE(cn2.display_name) WITHIN GROUP (GRAPH PATH) AS end_customer,
STRING_AGG(cn2.display_name, ' → ') WITHIN GROUP (GRAPH PATH) AS hops
FROM graph.customer_node AS cn1,
graph.uses_device FOR PATH AS ud1,
graph.device_node FOR PATH AS dn,
graph.uses_ip FOR PATH AS ui,
graph.ip_node FOR PATH AS ip,
graph.uses_device FOR PATH AS ud2,
graph.customer_node FOR PATH AS cn2
WHERE MATCH(SHORTEST_PATH(cn1(-(ud1)->dn-(ui)->ip<-(ui)-dn<-(ud2)-cn2)+))
) AS sp WHERE end_customer IS NOT NULL;