I have an Azure Data Explorer (ADX) aka. Kusto instance in combination with a PostgreSQL Flexible Server (16.4) and want to access a the SQL table test_adx_meta from ADX. There are no firewall or IP range limitations. I followed the…
I am wondering is there a way to remove consecutive duplicates. For example, if we have: [x,y,z,z,z,z, ...] I want [x,y,z, ...] | project ClusterName, NodeName, UserName LoadError | summarize LoadErrorSequence = make_list(LoadError) by ClusterName, NodeName, UserName | extend LoadErrorSequenceJson…
I'm new to Azure App insights and I'm creating an azure alert based on app insights logs. I have a simple KQL query here which returns a result when the exception count is above 10. I'm looking for ways to…
How can I calculate the number of overlapping days for each device in the given table, considering the time periods (StartDate to EndDate) for each device and check if and how much they overlap. The query needs to return the…
In Azure Monitoring logs, I have a whole bunch of data being passed from numerous servers and I want to be able to filter out certain records based on the server name being in a list of servers Something like…
I have a lot of log data that has some duplicate values except for two columns. The simplified query looks like this: AzureActivity | project TimeGenerated, CorrelationId, Caller, Action, RoleId, ObjectId This gives me a table that looks like this:…
I need to create a query to find logs where I can see requests and traces together and analyse if User SQL input queries are wrong? I could not find schéma over logs tables and how to join them ?…
Trying to write a KQL query where results should come when the table column Rawdata either contains any of the strings - job1 or job2 :- Tablename | where RawData contains "JOB1" OR "JOB2" The above gives me errror, what…
In my traces table, I've got messages like so: Incoming transaction: 0504250624105104 validated Incoming transaction: 0504250624105604 validated Incoming transaction: 0504250624105604 validated Incoming transaction: 0504250624105304 validated How can I find all non distinct/duplicate messages i.e. so the above returns only the…
How can I return results of a query that aren't in the results of another query? For example, I want to return the results that are returned from the first query and are not also in the second query: First…