Forum Discussion
Is there a way to find total Virtual machines using Azure logs
I want to collect data for all the VMs present. But I am able to use only VMComputer and Heartbeat table for this. It doesn't has the data for the VMs which are in shut down state. I need data for all...
GaryBushey - I would like to fetch the AzureSize, AzureLocation, Physical Memory for all the VMs
Some of that data is available in other Tables or from Metrics / API. See example Workbook here which uses Metrics
AzureActivity logs would help you, if you can add those?
If not you'll have to use something like a Workbook, pull data from the api or ARG (Azure resourceGraph) and merge with Heartbeat. A bit like this: