-
Notifications
You must be signed in to change notification settings - Fork 446
Top asks
noakup edited this page Sep 17, 2020
·
7 revisions
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
-
Azure Data Lake Analytics
-
Azure Data Lake Store Gen1
-
Azure Machine Learning (AML) Workspace
-
Databricks Workspace
-
Synapse Analytics Workspace
-
Function Apps
-
Public IP Address
-
VNET
-
Network Adapter
-
Network Security Group (NSG)
-
a query that identifies sequences (sequence_detect doesn't provide the desired results). For example:
input:
Datetime | ProcId | EventStr |
---|---|---|
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" |
The expected output:
ProcId | Start_Time | Stop_Time | Duration |
---|---|---|---|
0 | 2020-06-01T08:00:00Z | 2020-06-01T08:10:00Z | 00:10:00 |
1 | 2020-06-01T08:01:00Z | 2020-06-01T08:02:00Z | 00:01:00 |
1 | 2020-06-01T08:05:00Z | 2020-06-01T08:06:00Z | 00:01:00 |
2 | 2020-06-01T08:03:00Z | 2020-06-01T08:04:00Z | 00:01:00 |