CODEWITHSUNDEEP
azurekqlazure-log-analyticsazure-log-analytics-workspace
MoonHorse
MoonHorse

Reputation: 2479

what is the default sorting column in log analytics workspace with KQL queries?

I am querying Azure Log Analytics Workspace with KQL. I wonder by which column the rows in a table are ordered(sorted)? I am assuming that we don't use order. Is it sorted randomly?

Upvotes: 0

Views: 901

Answers (1)

RithwikBojja
RithwikBojja

Reputation: 11183

If table is maintaining datetime field (Ingestion Datetime Field mainly), generally by default its sorted-on date. But there is not as such ordering/sorting for time if considered and it is totally random.

enter image description here

If you want to order or sort it you can use : order by and dsc , asc in you kql query.

or you can use arrows to sort it: enter image description here

Upvotes: 1

Related Questions