You can use Azure Resource Graph to do this, but you are going to need a fairly complex query. Here is a great article that details how to do something similar with VM IP's.
AZURE: List ALL used IPs (public and private) within our subscription/tenant, no matter what they are assigned to (static or dynamic)...
Dirk Melvin
6
Reputation points
I have searched most of the day today, and I have found where lots have asked how to get a VMs public or private IP, or how to find available IPs, etc.
However, what I am looking for is a way to get a complete list of ALL IPs that are in use within our subscription/tenant. No matter what the IP is assigned to (VM, EndPoint, service, etc.).