Hi Alan
can you try this:
START ip=node:IPaddrNode('*:*')
OPTIONAL MATCH (nic)-[:ipowner]->(ip)
WHERE NOT ((host)-[:nicowner]->(nic))
RETURN ip, nic
ORDER BY ip.ipaddr
in 2.x syntax
MATCH (ip:IPAddress)
OPTIONAL MATCH (nic)-[:ipowner]->(ip)
WHERE NOT ((host)-[:nicowner]->(nic))
RETURN ip, nic
ORDER BY ip.ipaddr
On Tue, Sep 1, 2015 at 2:43 PM, Alan Robertson <[email protected]
<mailto:[email protected]>> wrote:
I just read my email, and it didn't seem like I gave good
context and explained things very clearly...
Let me try again and see if I can be a little clearer...
My problem domain is modelling IT environments (data centers,
clouds, etc). In this world, there are IP addresses, ethernet
chips (NICs) [which have MAC addresses], and hosts, to which
NICs are attached. We discover the interrelationships between
these different things. Sometimes we have all the
information, sometimes we have 2/3 of it and sometimes only
1/3 (IP addresses).
So...
I have IPs which are related to NICs, which are related to
(attached to) hosts.
I want to find all the (IP, NIC) pairs which have no
relationship to any host.
Some IPs will have an associated NIC, and some will not.
I want to retrieve all (IP, NIC) pairs where there is an
associated NIC, and (IP, NULL) for the cases where there is
no NIC.
In effect I want to know all the IP addresses which I don't
know everything about...
On 08/31/2015 09:59 PM, Alan Robertson wrote:
Hi,
I have a question about how to write a cypher query...
Here's the query that comes close to working ;-)
START ip=node:IPaddrNode('*:*')
OPTIONAL MATCH host-[:nicowner]->nic-[:ipowner]->ip
WITH ip, nic, host
WHERE host IS NULL
RETURN ip, nic
ORDER BY ip.ipaddr
This always returns ip, NULL. :-(
It returns the right ips, but I would like the nic for the
case that a nic exists in an ipowner relationship to an IP
address.
Sometimes there's just a standalone IP (with no associated NIC)
Sometimes there's an IP, NIC pair
and sometimes there's a host, IP, MAC triple.
I want to return the IP, NIC pair if it exists, and the IP
and NULL if there is no related NIC. But I want the NIC if
it exists.
How should I do this?
Thanks!
-- Alan Robertson
[email protected] <mailto:[email protected]>
--
Alan Robertson / CTO
[email protected]
<mailto:[email protected]>/ +1 303.947.7999
<tel:303.947.7999>
Assimilation Systems Limited
http://AssimilationSystems.com
Twitter <https://twitter.com/ossalanr> Linkedin
<https://www.linkedin.com/in/alanr> skype
<https://htmlsig.com/skype?username=alanr_unix.sh>
--
You received this message because you are subscribed to the
Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails
from it, send an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
Alan Robertson / CTO
[email protected]
<mailto:[email protected]>/ +1 303.947.7999
<tel:%2B1%20303.947.7999>
Assimilation Systems Limited
http://AssimilationSystems.com
Twitter <https://twitter.com/ossalanr> Linkedin
<https://www.linkedin.com/in/alanr> skype
<https://htmlsig.com/skype?username=alanr_unix.sh>
--
You received this message because you are subscribed to the
Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from
it, send an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the
Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected]
<mailto:[email protected]>.
For more options, visit https://groups.google.com/d/optout.
