A MAC-to-IP system receives IP and/or MAC lease information of network end-points from one or more DHCP servers providing services to a region of a multi-system subscriber access network. The lease information includes the MAC and IP addresses of devices that can be provisioned by a DHCP server serving the particular region as well as lease expiration information (i.e., time and date). The lease information can be extracted from issued leases and does not affect the issuance of leases by the DHCP server. A DNS-to-MAC-to-IP query interface receives a DNS lookup request for a network end-point from a network device and converts the DNS lookup request into a MAC-to-IP database query. Data is obtained from the MAC-to-IP database to fulfill the DNS lookup request and DNS lookup response is created and sent to the requesting network device.