Add Custom Query to somewhere like the IPAM Summary screen.
Enter the following -
Custom SWQL Query:
select fwd.Name, fwd.Data as IP, zon.Name as Zone
from IPAM.DnsRecord fwd
inner join IPAM.DnsZone zon
on fwd.DnsZoneId = zon.DnsZoneId
left join IPAM.DnsRecord rev
on rev.type = 12
and rev.ipAddressN = fwd.ipAddressN
where fwd.type=1 and fwd.IPAddressN is not null
and rev.ipAddressN is null
Tick [enable search]
Search SWQL Query:
select fwd.Name, fwd.Data as IP, zon.Name as Zone
from IPAM.DnsRecord fwd
inner join IPAM.DnsZone zon
on fwd.DnsZoneId = zon.DnsZoneId
left join IPAM.DnsRecord rev
on rev.type = 12
and rev.ipAddressN = fwd.ipAddressN
where fwd.type=1 and fwd.IPAddressN is not null
and rev.ipAddressN is null
AND ( fwd.name like '%${SEARCH_STRING}%' or zon.Name like '%${SEARCH_STRING}%' )
Minor edit thanks to jm_sysadmin :-)
