Network Information for IPs Without Attached Devices

Returns DNS A and AAAA records for IP addresses that don’t have a corresponding device in Device42 — useful for cleaning up DNS records or identifying opportunities for additional device discovery.

Click to expand the code block

select
    ds.ip_address
    ,ds.subnet_network
    ,ds.subnet_range_begin
    ,ds.subnet_range_end
    ,ds.mask_bits
    ,ds.dns_name
    ,ds.dns_type
    ,ds.dns_content
    ,ds.dnszone_name
from view_dbb_security_v2 ds
where ds.is_ip_device_assoc = 'No' and ds.dns_type in ( 'A', 'AAAA')