Top asks

Users ask for contributions for the following services:

• Azure Synapse and Azure Data Warehouse
• Azure Data Factory v2 (Resource-Specific Diagnostics)
• Security Center Continuous Export
• Azure Databricks

Also 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