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...
Hi,
Have you looked into using workbooks to visualize this information? Even if it is possible to get all this data in one query result, I think it would make more sense to build a workbook that you can use as a backup report.
Have you looked into using workbooks to visualize this information? Even if it is possible to get all this data in one query result, I think it would make more sense to build a workbook that you can use as a backup report.
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.- 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.