Fraud ring detayı

device:aaaaaaaaaaaa…

MEDIUM risk Paylaşılan cihaz 3 müşteri 22 toplam sipariş

İlişki ağı

Müşteriler (3) isim · şehir · sipariş

Müşteri	Şehir	Sipariş
Fatma Aydın #7	İzmir	8
Mehmet Demir #2	Ankara	8
Volkan Aksoy #15	Adana	6

Bağlı cihazlar (1)

aaaaaaaaaaaa…

T-SQL evidence (workshop) sql/22-fraud-ring.sql

-- Paylaşılan cihaz pattern (graph)
SELECT c.full_name, d.fingerprint, d.ip_address
FROM   graph.customer_node cn,
       graph.uses_device  ud,
       graph.device_node  dn,
       shop.customer      c,
       shop.device        d
WHERE  MATCH(cn-(ud)->dn)
  AND  c.customer_id  = cn.customer_id
  AND  d.device_id    = dn.device_id
  AND  LEFT(d.fingerprint, 12) = 'aaaaaaaaaaaa';