Azure Activity Logs query not returning any data.

Susheel Bhatt 351 Reputation points
2022-02-09T09:40:52.993+00:00

We are currently working on creating customized Azure dashboard based on the columns that we would like to see. But when we run kusto queries to fetch the data queries don't return anything.

Sample query :
AzureActivity | take 10

Other question that I have is :

How can I pull Azure Monitor data using Kusto query? Because "Perf" table isn't returning any data, though I can see it from Azure Monitor.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
2,783 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. SwathiDhanwada-MSFT 17,241 Reputation points
    2022-02-09T10:32:55.907+00:00

    @Susheel Bhatt When you are trying to query logs such as activity logs and Perf logs from log analytics workspace , the queries doesn't return the results. Kindly note you need to enable diagnostic settings for activity logs to send to logs to log analytics workspace.

    To enable diagnostic logs for Activity logs : Go to any resource -> Click on Activity Log Tab on left pane -> Click on Export Activity Logs -> Click on "Add Diagnostic Settings" link -> Enter the diagnostic name , Select the Logs , choose the log analytic workspace where you want to query your data. For more information, check this document.

    Similarly, Perf table contains information of Performance counters from Windows and Linux agents that provide insight into the performance of hardware components operating systems and applications. On how to collect this data, check this document.

    0 comments No comments