How to query duplicate IP adresses

[Kundenservice]

Hello,

i have DNS trouble. Some names are redirected to the same IP. On my ePO i want to query all duplicate systems with a duplicate IP, like the default query for duplicate systemnames.

There is an old community entry without a solution. Only with workaround.

Is it possible to query it now? Anyone an idea?

Thanks.

[LKS]

Hi Kundenservice,

There is a default Query available under "Queries & Report" which will pull all the duplicate entries from your system tree.

Query name : Duplicate System Names

Was my reply helpful?

If you find this post useful, please give it a Kudos! Also, please don't forget to select "Accept as a Solution" if this reply resolves your query!

[Kundenservice]

Hi LKS,

thanks for your reply, but unfortunately it is not helpful. I had written, i´m searching for a solution like the default query for duplicate systemnames. I need a solution for IP´s.

[cdinet]

You can try this - and this assumes the table name, please verify it is correct.

Select computername, IPAddress from EPOcomputerpropertiesMT where ( ipaddress in ( SELECT a.ipaddress FROM EPOcomputerpropertiesMT AS a, EPOcomputerpropertiesMT AS b WHERE a.ipaddress=b.ipaddress AND a.parentID!=b.parentID AND a.ipaddress != ' ' ) )