Forum Discussion
Need to join the Azure diagnostics and Resource specific
Dear Team, I am looking for getting the result of both tables (Azure diagnostics and Resource specific) in a single query. we have configured with both options in the log analytics workspace...
Anders Bengtsson yes, we are using log analytics workspace. It not sure how to build a single query. Can you help with this, please?
Hi,
Before we start writing new queries, I want to make sure you have looked at Backup Explorer.
If you go into your Backup Vault, there is a link to Backup Explorer. It is in early status but might be what you are looking for. For more information see https://docs.microsoft.com/en-us/azure/backup/monitor-azure-backup-with-backup-explorer#:~:text=Backup%20Explorer%20is%20a%20built,%2C%20resource%20groups%2C%20and%20vaults.
Before we start writing new queries, I want to make sure you have looked at Backup Explorer.
If you go into your Backup Vault, there is a link to Backup Explorer. It is in early status but might be what you are looking for. For more information see https://docs.microsoft.com/en-us/azure/backup/monitor-azure-backup-with-backup-explorer#:~:text=Backup%20Explorer%20is%20a%20built,%2C%20resource%20groups%2C%20and%20vaults.
- Dear Anders Bengtsson,
Yes, I have checked the Backup Explorer. But we have 2000 Recovery Services vault and 4 log analytics workspaces. So we want to get in one short using the query. Currently using above one but due to recent changes, we need a modification. Kindly help on those, please.- Hi,
At https://docs.microsoft.com/en-us/azure/backup/backup-azure-monitoring-use-azuremonitor#sample-kusto-queries you can see example queries for working with backup logs. Make sure you have configured your backup vaults to send logs to the Log Analytics workspace.
If you have multiple log analytic workspaces you can do a cross-workspace-query to see data from all workspaces. https://docs.microsoft.com/en-us/azure/azure-monitor/logs/cross-workspace-query.Anders Bengtsson -I have gone through the page already. I was looking for the custom one, which I was updated initially on top. Kindly someone help with this.