Azure Activity Logs query not returning any data.

Question

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.

Answer 1

@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.