ip:203.0.113.49

-- 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;