IP Address filtering using device name

[jnc27]

Hi,
I am trying to filter IP addresses if name contains a certain string and tenant.id. I tried this one:

ips = IPAddress.objects.filter(interface__device__name__contains=ip_filter, tenant_id=t.id)

Is this the proper way to filter IP addresses? I am using this in a custom script - but the script takes a long time and runs to a timeout.

Device and VMs I can succesfully filter like this:
Device.objects.filter(name__contains=dev_filter, tenant_id=t.id)
VirtualMachine.objects.filter(name__contains=vm_filter, tenant_id=t.id)

Thank you..

[jnc27]

Is it somehow a general problem as I can not iterate through the IPAddress object.
When doing this it results to:

Traceback (most recent call last):
  File "/opt/netbox/venv/lib/python3.9/site-packages/rq/worker.py", line 1061, in perform_job
    rv = job.perform()
  File "/opt/netbox/venv/lib/python3.9/site-packages/rq/job.py", line 821, in perform
    self._result = self._execute()
  File "/opt/netbox/venv/lib/python3.9/site-packages/rq/job.py", line 844, in _execute
    result = self.func(*self.args, **self.kwargs)
  File "/opt/netbox/netbox/extras/scripts.py", line 489, in run_script
    _run_script()
  File "/opt/netbox/netbox/extras/scripts.py", line 481, in _run_script
    job_result.save()
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/base.py", line 806, in save
    self.save_base(
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/base.py", line 857, in save_base
    updated = self._save_table(
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/base.py", line 970, in _save_table
    updated = self._do_update(
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/base.py", line 1034, in _do_update
    return filtered._update(values) > 0
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/query.py", line 885, in _update
    return query.get_compiler(self.db).execute_sql(CURSOR)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1783, in execute_sql
    cursor = super().execute_sql(result_type)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1348, in execute_sql
    sql, params = self.as_sql()
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1749, in as_sql
    val = field.get_db_prep_save(val, connection=self.connection)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 910, in get_db_prep_save
    return self.get_db_prep_value(value, connection=connection, prepared=False)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/fields/__init__.py", line 905, in get_db_prep_value
    value = self.get_prep_value(value)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/models/fields/json.py", line 96, in get_prep_value
    return json.dumps(value, cls=self.encoder)
  File "/usr/local/lib/python3.9/json/__init__.py", line 231, in dumps
    return _default_encoder.encode(obj)
  File "/usr/local/lib/python3.9/json/encoder.py", line 199, in encode
    chunks = self.iterencode(o, _one_shot=True)
  File "/usr/local/lib/python3.9/json/encoder.py", line 257, in iterencode
    return _iterencode(o, 0)
  File "/usr/local/lib/python3.9/json/encoder.py", line 179, in default
    raise TypeError(f'Object of type {o.__class__.__name__} '
TypeError: Object of type IPAddress is not JSON serializable