skip to Main Content

Azure – Kusto (KQL), How to pivot event rows that are grouped into single lines (by user and day), including event start and end times?

I hope somebody can help me with a tricky Kusto query. I have the following dataset, which contains events raised by user, where events are represented with event code: datatable(CreatedDate:datetime, User:string, EventCode:string) [ datetime(4-22-2024 12:44:02.750 PM), "user1", "TS", datetime(4-23-2024 4:09:30.551…

VIEW QUESTION

Azure Steam Analytics Query

I want to store the below JSON data to the Azure table. Here the input and the output for Azure Stream Analytics are Azure IoT Hub and table respectively. [ { "device1": [ { "name": "temperature", "value": 50 }, "name":…

VIEW QUESTION
Back To Top
Search