Report on duplicate addresses and prefixes #629

Closed
opened 2025-12-29 16:24:04 +01:00 by adam · 3 comments
Owner

Originally created by @candlerb on GitHub (Jan 16, 2017).

Unless you have ENFORCE_GLOBAL_UNIQUE configured, it is possible to add duplicate IP addresses. Once they have been added, they may no longer be noticed.

Suggest having some sort of report which highlights duplicate IPs. Could also be done on a per-VRF basis (for VRFs which don't have enforce uniqueness)

Originally created by @candlerb on GitHub (Jan 16, 2017). Unless you have ENFORCE_GLOBAL_UNIQUE configured, it is possible to add duplicate IP addresses. Once they have been added, they may no longer be noticed. Suggest having some sort of report which highlights duplicate IPs. Could also be done on a per-VRF basis (for VRFs which don't have enforce uniqueness)
adam closed this issue 2025-12-29 16:24:04 +01:00
Author
Owner

@Armadill0 commented on GitHub (Jan 17, 2017):

I just wanted to ask the same.

Maybe this could be solved by a "Duplicates" filter on the IP addresses list page where the duplicates are grouped or something like that.

@Armadill0 commented on GitHub (Jan 17, 2017): I just wanted to ask the same. Maybe this could be solved by a "Duplicates" filter on the IP addresses list page where the duplicates are grouped or something like that.
Author
Owner

@candlerb commented on GitHub (Jan 23, 2017):

Workaround:

echo "select vrf_id,address,count(*) from ipam_ipaddress group by vrf_id,address having count(*) > 1;" | su -c 'psql netbox' postgres

Maybe a solution is to have a "custom reports" table in the Admin section, where you just enter a report name and some SQL; then have a drop-down menu in the main UI to run any of the chosen reports.

@candlerb commented on GitHub (Jan 23, 2017): Workaround: ~~~ echo "select vrf_id,address,count(*) from ipam_ipaddress group by vrf_id,address having count(*) > 1;" | su -c 'psql netbox' postgres ~~~ Maybe a solution is to have a "custom reports" table in the Admin section, where you just enter a report name and some SQL; then have a drop-down menu in the main UI to run any of the chosen reports.
Author
Owner

@jeremystretch commented on GitHub (Oct 9, 2017):

This functionality will be provided via custom validation reports (#1511) in v2.2.

@jeremystretch commented on GitHub (Oct 9, 2017): This functionality will be provided via custom validation reports (#1511) in v2.2.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#629