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 ;-)
>
> Konsole output
> 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]
>
>
>
>
> --
>
> Alan Robertson / CTO
> [email protected] <mailto:[email protected]>/
> +1 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
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].
For more options, visit https://groups.google.com/d/optout.
