change Giga bytes to peta bytes in kusto query?
I have a kusto query that have two columns as shown below & size column is in Giga bytes
ADX – KQL: Conditionally Extending Property Columns from Dynamic Column
let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]
ADX – KQL: Conditionally Extending Property Columns from Dynamic Column
let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]
ADX – KQL: Conditionally Extending Property Columns from Dynamic Column
let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]
ADX – KQL: Conditionally Extending Property Columns from Dynamic Column
let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]
ADX – KQL: Conditionally Extending Property Columns from Dynamic Column
let systems = datatable(traceName: string, trace: string) [ ‘Temp1’, ‘trace_1_temperature’, ‘Temp2’, ‘trace_2_temperature’, ‘Temp3’, ‘trace_3_temperature’ ]; let telemetry = datatable(timestamp: datetime, data: dynamic) [ datetime(2023-09-11T10:00:00Z), dynamic({‘trace_1_temperature’: 35, ‘trace_2_temperature’: 40, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:05:00Z), dynamic({‘trace_1_temperature’: 36, ‘trace_3_temperature’: 42, ‘voltage’:5, ‘active’:’true’}), datetime(2023-09-11T10:10:00Z), dynamic({‘trace_2_temperature’: 38, ‘trace_3_temperature’: 41, ‘voltage’:5, ‘active’:’true’}) ]; My desired output hardcoded for this case: let hardCodedDesiredOutput = […]
How to do a KQL time window join at millisecond granularity?
I am attempting to join the processName of the first table into the event log output:
Need suggestion to implement restrictive permissions to Kusto Tables and Functions
I would like to restrict viewer permissions of a specific Security Group to all database objects except few functions. In other words, the members of that one security Group should be only able to seeexecute 10 functions. Should not be able to directly query the table(s) schema.
Azure Data Explorer calculate history of changes
I hope you can help me. That problem makes me crazy…
Given a table, which shows the booked services of devices. There is a new entry per device, if the booked services changed.
has_all(): failed to cast argument 2 to scalar constant
I have a dynamic list of strings that I want to compare with a value of a column in main_table. I want to make sure all the parts from this list match my column.