List IP Addresses using Azure Resource Graph Explorer

When working for a large enterprise customer there are often requirements to search for a cloud resource. For example, recently an incident was reported we had to decide if IP address in the Service Ticket was on-prem or on one of the public clouds. Such a request could be made for VM name as well.

Fortunately, Azure Resource Graph Explorer in Azure Portal make it easier for such requests.

Azure Resource Graph acts as a database of resources with tables that can be queried using Kusto.

Here is an example to list all ResourceGroups.

This is a great tool to build your inhouse inventory of resources using Kusto queries.