Home / server / Questions / 981206
In Process
Glen Little
Asked: 2019-08-30 09:26:10 +0800 CST

Specifying columns in Azure Log Analytics query

  • 772

In the Azure Kusto query system, I can add columns by manually typing them in using project :

AzureDiagnostics
| project TimeGenerated, httpMethod_s

or by selecting them with the "columns" button:

enter image description here

But when I select the columns I want visually, the query does not get updated and if I save the query, the choice of columns is not saved.

How can I update the query text to include the columns I've just selected?

azure

1 Answers

  1. You have to specify the columns you want in the query, like I have done on the last line below.

    [AzureDiagnostics
| where ResourceProvider =="MICROSOFT.DBFORPOSTGRESQL" 
| where Category == "PostgreSQLLogs"
and not (Message contains "connection")
and not (Message contains "does not exist") 
 | sort by TimeGenerated desc
 | project TimeGenerated, Message
    • 3