This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 42%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Hello,
I can locate ‘Resources’ table in Azure Resource Graph Explorer. However, I want to create alerts based on Resources Table data in Log Analytics workspace. Can anyone please update How can we get this ‘Resources ‘table in Log Analytics workspace and then create Azure monitor alert?
The Resource table will include data about ALL references.
You can create an alert from a log analytics query here: https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/tutorial-log-alert
What specifically are you after?
I am looking for provisioning state of azure resources which is available in resources.properties. I know to create alert in LA workspace but I don't find resources properties data or resource table in LA , I checked all available tables there.
Supported resources are here: https://learn.microsoft.com/en-us/azure/governance/resource-graph/reference/supported-tables-resources
You can go into a specific resource, and then look up that detail, ie a Storage account: https://github.com/aryankashyap7/CheatSheets-for-Developers/blob/0d15cfa566f6c4d987b888042b2da448a4c35fb4/src/pages/sheet/azure.md?plain=1#L103
ie resources.properties.allowBlobPublicAccess
See below for an example:
resources| where type == "microsoft.storage/storageaccounts"| projectname,properties.allowBlobPublicAccess,publicAccess= properties['publicNetworkAccess'] ,properties.minimumTlsVersion
@Luke Murray Thanks for your response. Our resources are located in customer subscriptions spread across. We want to collect this Resource table for monitoring the specific Resource properties to a centralized workspace, Kusto etcc , so that we can be able to setup Azure Monitoring on these.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 41%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Sanjay Khandelwal, there is no direct way to integrate resource graph with Log Analytics. Based on your question and subsequent comment, I see that you are trying to create an alert for resource provisioning. You could do it in 2 different ways
Hope it helps. Please let me know if you have any questions.
Please 'Accept as answer' if it helped so that it can help others in the community looking for help on similar topics.
Sanjay Khandelwal, following up to check if the response above helped. Please let us know if you have any questions.
Please 'Accept as answer' if it helped so that it can help others in the community looking for help on similar topics.
@AnuragSingh-MSFT Thanks for your response. The Acitvity Logs are not containeing the Resource properties and their status as available in Resource Table. Our resources are located in customer subscriptions spread across. We want to collect this Resource table for monitoring the specific Resource properties to a centralized workspace, Kusto etcc , so that we can be able to setup Azure Monitoring on these. Could you please suggest?
Sanjay Khandelwal, thank you for the reply. Yes, the activity log will not be at par with the resource graph explorer. But this is also one of the areas which can be looked at, if you are interested in getting information about resource creation/update.
As mentioned above, the workaround to use LogicApps (or similar tool) to query the Resource Graph Explorer could also be used. In the end, it would come down to the exact use case. Based on that, you may choose one of the options.
Hope it helps.