Home / server / Questions / 1167461
Accepted
Wayne Jondle
Asked: 2024-11-06 05:36:58 +0800 CST

Windows DNS server list all records all zones containing CIDR

  • 772

From powershell, I can run Get-DnsServerResourceRecord -zonename "test.com" to get all records in the zone.

I can load all zones to a variable, and use a for loop to get all records in all zones.

What I want is all records from all zones with a record containing an IP address within a CIDR range.

Example: I want all records in all zones that have a value of 10.10.10.1/24 The return would hopefully contain zone, record type, record name, and value E.G. temp.com, A Record, www, 10.10.10.10 test.org, cname, host1, 10.10.10.25 etc

windows

1 Answers

  1. Best Answer

    The first thing to note is that when querying DNS, each type of DNS record has a different property to query, so there is no way to just query a record for anything matching "mydomain.foo" and get back all the CNAME, MX, TXT, NS records that might have that string. So the query below is specifically for finding IPv4 addresses in A records.

    Since you're searching for a /24 the simplest option is to simply search for the first 3 octets. So :

    $searchIP="10.10.10."
$zonelist=get-dnsserverzone
ForEach ($zone in $zonelist)
{
    get-dnsserverresourcerecord -zonename $Zone.zonename | 
        Where-Object {$_.RecordData.ipv4address -match $searchIP} | 
        select @{N="ZoneName";E={$Zone.zonename}},HostName,RecordType,@{N="IPv4 Address";E={$_.RecordData.ipv4address}} | 
        Format-Table
}

    You could with some string wrangling search for a subset of the /24, but since the IP addresses are strings not numbers, it gets complicated.

    Note, the query bit itself is :

    Where-Object {$_.RecordData.ipv4address -match $searchIP}

    where the critical element is :

    RecordData.ipv4address

    You can similarly query other record types using the other properties found within RecordData, some examples of which are :

    RecordData.HostNameAlias
RecordData.MailExchange
RecordData.DomainName
RecordData.DescriptiveText
RecordData.PrimaryServer
RecordData.NameServer
RecordData.IPv6Address
RecordData.PtrDomainName
    • 0