How to Search across all hosted zones for records either by name of record or IP address.

Question

Is their a simple way to search across all hosted zones looking for records either by name or IP address. We have more than 1200 zones in Route 53. 
I would like to be able to search for all a records that have a specific ip IE i want to see all records that match 200.200.200.12 or iwant to search for any resource records across all zones that have txt record called verify-service. currently the only way i see to do that would be to write a script that first gets a list of all zones then search each zone individually and concatonate those in to a single response. I dont see any way to make that work quickly if it have to make a separate API call for each zone. With the api limit of 5 requests per second it would take a least 4 minutes per search and we plan on adding at least another 600 zones in the next 12 months..

Answer

Given the limits of the API in terms of call rates, why not maintain an external list of the records somewhere? Something that could be updated daily (say) by doing the API calls in a measured way.

At its simplest it could be a text file (or series of files) that you use something like `grep` to search. More complex: Store the records as CSV in S3 and use Athena to query using SQL.

Thinking bigger: If you're managing a lot of zones, how are you automating the creation and update of those zones? If it's all manual you might find that you get less errors and faster updates by storing the records externally anyway and pushing updates into Route 53 using some sort of scripting. Again, doesn't have to be complex but it saves time not having to do click-ops.

How to Search across all hosted zones for records either by name of record or IP address.

Relevant content