Find all CNAME or Alias for a DNS A record

The below PowerShell command finds all the CNAME records pointing to a specific A record.
It is assumed that you have DNS PowerShell modules already loaded (by installing RSAT or DNS management tools)

Get-DnsServerResourceRecord -ZoneName DNSZone -ComputerName DnsServer | where{$_.hostname -like "DNSRecord"} | select hostname -ExpandProperty recorddata

DNSZone is the name of DNS zone you want to search in
DnsServer is the DNS server you want to connect to
DNSRecord is the Record for which you want to search the CNAME or Alias.

Get-DnsServerResourceRecord -ZoneName -ComputerName DNSSvr01 | where{$_.hostname -like "FileSvr01*"} | select hostname -ExpandProperty recorddata

And yes you can use wildcard (*) character for A record string.