Top asks

Users ask for contributions for the following services and scenarios:

• Azure Synapse and Azure Data Warehouse

• Azure Data Factory v2 (Resource-Specific Diagnostics)

• Security Center Continuous Export

• Azure Databricks

• a query that identifies sequences (sequence_detect doesn't provide the desired results). For example: let Table1 = datatable (Time:datetime, ProcId:int, Action:string) [ datetime(2020-06-01 8:00), 0, "Start", datetime(2020-06-01 8:01), 1, "Start", datetime(2020-06-01 8:02), 1, "Exit", datetime(2020-06-01 8:03), 2, "Start", datetime(2020-06-01 8:04), 2, "Exit", datetime(2020-06-01 8:05), 1, "Start", datetime(2020-06-01 8:06), 1, "Exit", datetime(2020-06-01 8:10), 0, "Exit", ]; Table1 | evaluate sequence_detect(Time, 1d, 1d, Start = Action == "Start", Stop = Action == "Exit", ProcId)

The output would be:

ProcId	Start_Time	Stop_Time	Duration
1	2020-06-01T08:01:00Z	2020-06-01T08:06:00Z	00:05:00
2	2020-06-01T08:03:00Z	2020-06-01T08:04:00Z	00:01:00
0	2020-06-01T08:00:00Z	2020-06-01T08:10:00Z	00:10:00