BUCH-Facility Bucharest

This facility's networks present, hosted exchanges and CDN operators.

MATCH (f:FACILITY {id: $id})
OPTIONAL MATCH (f)<-[:AS_PRESENT_AT]-(a:ASN)
WITH f, collect(a.name)[0..25] AS sampleAsns
OPTIONAL MATCH (f)<-[:IX_HOSTED_AT]-(ix:INTERNET_EXCHANGE)
WITH f, sampleAsns, collect({id: ix.id, name: ix.name})[0..25] AS sampleExchanges
OPTIONAL MATCH (f)<-[:CDN_POP_AT]-(cdn:CDN_POP)
WITH f, sampleAsns, sampleExchanges, collect(DISTINCT cdn.operator)[0..10] AS cdnOperatorNames
OPTIONAL MATCH (v:VENDOR) WHERE v.name IN cdnOperatorNames
WITH f, sampleAsns, sampleExchanges, cdnOperatorNames, collect(v.name) AS linkedCdnVendors
RETURN f.name AS name, f.orgName AS orgName, f.city AS city, f.countryCode AS countryCode,
       f.region AS region, f.networkCount AS networkCount, f.ixCount AS ixCount,
       f.carrierCount AS carrierCount, f.status AS status, f.threatNetworkCount AS threatNetworkCount,
       sampleAsns, sampleExchanges, cdnOperatorNames, linkedCdnVendors