3

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?

2
  • You select/include columns with “project” (, which you already state so I don’t fully understand your problem/question? (Project Timegenerated,httpmethod_s,OperationName, Category
    – Jarnstrom
    Aug 30 '19 at 7:11
  • @Jarnstrom If I adjust the list of columns using the visual selector, the query text does not get updated. Is there any way to update the query to match what has been selected? Aug 31 '19 at 16:21
2

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.