next attempt :) the where is pulled INTO the optional match so we have to
add the WITH back to avoid that.
START ip=node:IPaddrNode('*:*')
OPTIONAL MATCH (nic)-[:ipowner]->(ip)
WITH nic,ip
WHERE NOT (()-[:nicowner]->(nic))
RETURN ip, nic
ORDER BY ip.ipaddr
in 2.x syntax
MATCH (ip:IPAddress)
OPTIONAL MATCH (nic)-[:ipowner]->(ip)
WITH nic,ip
WHERE NOT (()-[:nicowner]->(nic))
RETURN ip, nic
ORDER BY ip.ipaddr
On Tue, Sep 1, 2015 at 6:47 PM, Alan Robertson <[email protected]> wrote:
> I made the change, and now it returns *every* IP address.
>
> Some it shows as having a NULL nic, but in the database, the nic is there
> - as is the host.
>
> It is now producing about the same results as my "allips" query except
> *much* faster and without the host information...
>
>
> On 09/01/2015 09:37 AM, Wes Freeman wrote:
>
> just take out host and make it WHERE NOT ()-[:nicowner]->(nic)
>
>
> On Tue, Sep 1, 2015 at 10:53 AM, Alan Robertson <[email protected]> wrote:
>
>> I tried the old syntax, and it said that host was undefined.
>>
>>
>> On 09/01/2015 08:45 AM, Michael Hunger wrote:
>>
>> 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]> 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]
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Alan Robertson / CTO
>>> [email protected] / +1 303.947.7999
>>>
>>> Assimilation Systems Limited
>>> http://AssimilationSystems.com
>>>
>>> [image: Twitter] <https://twitter.com/ossalanr> [image: Linkedin]
>>> <https://www.linkedin.com/in/alanr> [image: 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.
>>>
>>>
>>>
>>> --
>>>
>>> Alan Robertson / CTO
>>> [email protected] / +1 303.947.7999 <%2B1%20303.947.7999>
>>>
>>> Assimilation Systems Limited
>>> http://AssimilationSystems.com
>>>
>>> [image: Twitter] <https://twitter.com/ossalanr> [image: Linkedin]
>>> <https://www.linkedin.com/in/alanr> [image: 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.
>>>
>>
>> --
>> 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.
>>
>>
>>
>> --
>>
>> Alan Robertson / CTO
>> [email protected] / +1 303.947.7999 <%2B1%20303.947.7999>
>>
>> Assimilation Systems Limited
>> http://AssimilationSystems.com
>>
>> [image: Twitter] <https://twitter.com/ossalanr> [image: Linkedin]
>> <https://www.linkedin.com/in/alanr> [image: 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.
>>
>
> --
> 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.
>
>
>
--
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.
