Report on missing primary addresses #680

New Issue

adam · 2025-12-29T16:24:42+01:00

adam commented

2025-12-29 16:24:42 +01:00

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

It would be helpful to identify:

Devices which have at least one IPv4 address, but no Primary IPv4 address has been chosen
Devices which have at least one IPv6 address, but no Primary IPv6 address has been chosen

These can be identified using an ad-hoc query:

select dev.name,addr.family,addr.address
from dcim_device dev
join dcim_interface intf on dev.id = intf.device_id
join ipam_ipaddress addr on intf.id = addr.interface_id
where (dev.primary_ip4_id is null and addr.family = 4)
   or (dev.primary_ip6_id is null and addr.family = 6)
order by dev.name;

Ideally if there is only one choice, I'd like to be able to connect the primary address automatically. These candidates can be identified:

select dev.name,addr.family,min(addr.address),count(*)
from dcim_device dev
join dcim_interface intf on dev.id = intf.device_id
join ipam_ipaddress addr on intf.id = addr.interface_id
where (dev.primary_ip4_id is null and addr.family = 4)
   or (dev.primary_ip6_id is null and addr.family = 6)
group by dev.id,addr.family
having count(*) = 1;

However my SQL knowledge doesn't extend to nesting this with an UPDATE :-)

Originally created by @candlerb on GitHub (Jan 31, 2017). It would be helpful to identify: * Devices which have at least one IPv4 address, but no Primary IPv4 address has been chosen * Devices which have at least one IPv6 address, but no Primary IPv6 address has been chosen These can be identified using an ad-hoc query: ~~~ select dev.name,addr.family,addr.address from dcim_device dev join dcim_interface intf on dev.id = intf.device_id join ipam_ipaddress addr on intf.id = addr.interface_id where (dev.primary_ip4_id is null and addr.family = 4) or (dev.primary_ip6_id is null and addr.family = 6) order by dev.name; ~~~ Ideally if there is only one choice, I'd like to be able to connect the primary address automatically. These candidates can be identified: ~~~ select dev.name,addr.family,min(addr.address),count(*) from dcim_device dev join dcim_interface intf on dev.id = intf.device_id join ipam_ipaddress addr on intf.id = addr.interface_id where (dev.primary_ip4_id is null and addr.family = 4) or (dev.primary_ip6_id is null and addr.family = 6) group by dev.id,addr.family having count(*) = 1; ~~~ However my SQL knowledge doesn't extend to nesting this with an UPDATE :-)

adam closed this issue

2025-12-29 16:24:42 +01:00

adam commented

2025-12-29 16:24:42 +01:00

@jeremystretch commented on GitHub (Jan 31, 2017):

There's a lot of stuff we could do reporting on, and I've purposely avoided opening that can of worms for now. However, if you're reasonably versed in Python and interested in learning Django's ORM, it's pretty easy to generate whatever form of report you'd like. Here's an example.

Devices which have at least one IPv4 address, but no Primary IPv4 address has been chosen

./manage.py shell
Python 2.7.6 (default, Jun 22 2015, 17:58:13) 
[GCC 4.8.2] on linux2
Type "help", "copyright", "credits" or "license" for more information.
(InteractiveConsole)
>>> from dcim.models import Device
>>> Device.objects.filter(primary_ip4=None).exclude(interfaces__ip_addresses__isnull=True)

@jeremystretch commented on GitHub (Jan 31, 2017): There's a _lot_ of stuff we could do reporting on, and I've purposely avoided opening that can of worms for now. However, if you're reasonably versed in Python and interested in learning [Django's ORM](https://docs.djangoproject.com/en/1.10/intro/overview/), it's pretty easy to generate whatever form of report you'd like. Here's an example. > Devices which have at least one IPv4 address, but no Primary IPv4 address has been chosen ``` ./manage.py shell Python 2.7.6 (default, Jun 22 2015, 17:58:13) [GCC 4.8.2] on linux2 Type "help", "copyright", "credits" or "license" for more information. (InteractiveConsole) >>> from dcim.models import Device >>> Device.objects.filter(primary_ip4=None).exclude(interfaces__ip_addresses__isnull=True) ```

Sign in to join this conversation.

Branches Tags

main

update-changelog-comments-docs

feature-removal-issue-type

20911-dropdown

20239-plugin-menu-classes-mutable-state

21097-graphql-id-lookups

feature

fix_module_substitution

20923-dcim-templates

20044-elevation-stuck-lightmode

feature-ip-prefix-link

v4.5-beta1-release

20068-import-moduletype-attrs

20766-fix-german-translation-code-literals

20378-del-script

7604-filter-modifiers-v3

circuit-swap

12318-case-insensitive-uniqueness

20637-improve-device-q-filter

20660-script-load

19724-graphql

20614-update-ruff

14884-script

02496-max-page

19720-macaddress-interface-generic-relation

19408-circuit-terminations-export-templates

20203-openapi-check

fix-19669-api-image-download

7604-filter-modifiers

19275-fixes-interface-bulk-edit

fix-17794-get_field_value_return_list

11507-show-aggregate-and-rir-on-api

9583-add_column_specific_search_field_to_tables

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/netbox#680