python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - kusto-explorer

Kusto Query Specific child records

Is there a way to setup a where clause in Kusto to get specific records with child records Like if I wanted Kyle from below Where address has Code = street and that value= grant AND Code = Number and...
test-img

Zach

azure-data-explorer

kusto-explorer

Votes: 0

Answers: 1

Latest Answer

you could try using mv-apply, and filter for records in which the number of conditions met is as expected: datatable(i:int, d:dynamic) [ 1, dynamic({"Firstname": "Bob", "...
test-img

Yoni L.

Make the value as 0, if rows not available in Kusto

My query has count function which returns the count of rows summarized by day. Now, when there are no rows from that table, I'm not getting any result, instead I need, rows with all days and count as ...
test-img

Alekhya Yalla

azure-data-explorer

kql

kusto-explorer

Votes: 0

Answers: 1

Latest Answer

Instead of summarize you need to use make-series which will fill the gaps with a default value for you. exceptions | where name == 'my_scheduler' and timestamp > ago(30d) | extend day = split(tostr...
test-img

Slavik N

How to read JSON field in Kusto query when fields are dynamic

I am working with the JSON data (below) resulting from following query. SignInLogs | project AddtionalDetails Results [{"value":"test.com","key":"TenantId"},{&...
test-img

Razi

azure-data-explorer

kql

kusto-explorer

Votes: 0

Answers: 1

Latest Answer

Something like this? let T =datatable(AdditionalDetails:dynamic )[dynamic([{"value":"test.com","key":"TenantId"},{"value":"PC100921","k...
test-img

Avnera

Kusto | KQL: Expand dynamic column to all combinations of two ( Couples | Tuples )

I have a scenario where I am trying to create a view that shows me all the unique couples of values per key. For example: datatable(Key:string, Value:string)[ '1', 'A', '2', 'B', '2', 'C', '3', 'A'...
test-img

PorgtheEaten

azure-data-explorer

kql

kusto-explorer

Votes: 0

Answers: 1

Latest Answer

Here's a not too elegant nor efficient way, that uses an inner self join to get all combinations per Key datatable(Key:string, Value:string) [ '1', 'A', '2', 'B', '2', 'C', '3', 'A',...
test-img

Yoni L.

Posts

Questions

Blogs

Jobs