python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - kql

Three data sets in the KQL chart

I have three data sets: RequestType SuccessType ClientName External Full Client 1 External Partial Client 1 External Fail Client 1 Internal Full Client 1 Internal Partial Client 1 In...
test-img

Vlad

azure

data-visualization

kql

Votes: 0

Answers: 1

Latest Answer

This kind of visualization is not supported right now. Please suggest and upvote at: https://aka.ms/adx.uservoice
test-img

Alexander Sloutsky

Exclude certain days/time from query results? (Ex. Thursday's midnight-2am EST)

I am newer to KQL and I am trying to write a query against configuration changes made to files with an extension of ".config" and would like to remove results that are generated under the &q...
test-img

VoD

datetime

azure-data-explorer

kql

Votes: 0

Answers: 1

Latest Answer

Replace 4d with 4, because dayofweek() returns the number of day (between 0 and 6).
test-img

Slavik N

Create an array from the output of POST request in JSON Object

I'm trying to send an email via Logic App. The content must be an array of an orphaned resources. I am using an HTTP request to query the Azure resource graph explorer, on the Output I have a JSON obj...
test-img

Makina74

httprequest

azure-logic-apps

kql

azure-resource-graph

Votes: 0

Answers: 3

Latest Answer

Here is how it worked for me: Taking provided JSON into consideration Instead of having body as From data in Create HTML table I have used data since the Create HTML table takes only array as input an...
test-img

SwethaKandikonda

Parsing an array in Kusto QL - extracting a specific value

I am trying to parse the data from LoggedOnUsers column and extract a value of 'UserName' field. My query gives me an empty field as a result. DeviceInfo | extend field=todynamic(LoggedOnUsers) | proj...
test-img

slawek

azure-data-explorer

kql

Votes: 0

Answers: 1

Latest Answer

Your LoggedOnUsers value is an array of objects, so to extract the UserName you need to first extract the first item in the array, like this: let DeviceInfo = datatable(LoggedOnUsers:dynamic) [ dy...
test-img

Slavik N

Posts

Questions

Blogs

Jobs