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 ?…
Update on 25 June - 2 (SOLVED) How could I have been so foolish... I set up a secret generic and modified the deployment.yaml to assign variables. And it worked... To sum up my questions, all were caused by not…
I'm trying to ingest some Microsoft Flow API data into Azure Log Analytics. Goal is that a Power Automate send a JSON with the Flows details to Log Analytics. Here is the sample JSON : { "body": [ { "NAME":…
I'm trying to enable Azure Monitor for VMs using Terraform. The current code for enabling Azure Monitor for VMs is as follows: # Deploy the Azure data collection endpoint for monitoring Windows VM. resource "azurerm_monitor_data_collection_endpoint" "vminsights" { name = local.dce_azure_monitor_name…
I am currently working on an Alert Rule in Log Analytics which is supposed to look back for 90 days, calculate a confidencelimit over that time and then compare today's value with the limit. If today's value exceeds the statistic,…
Based on the Microsoft documentation it is possible to query external data via KQL using "externaldata". I wanted to test it out and created a storage account and then simple table within (the table is in "Tables" not in "Containers")…
The Copy Activity result doesn't show the source and sink location (file path or server etc.) Not from the ADF monitor or Log Analytics. It only shows the source and sink type. It is impossible to trace where the data…
I am getting a summary of our log analytics workspaces in the company, this includes the tables that are being used in each workspace, as well as other data such as the ingestion volume. The closest thing to "get" this…
I have a basic azure alert where it looks at the windows logs of a VM, and determines whether it should fire an alert upon detecting a specific event ID Event | where EventID == "500" | summarize arg_max(TimeGenerated, *)…
How can I export logs from Azure in JSON format? and what is the best practicee to do that? There is the option to use direct Kusto queries and export the logs to CSV, but in this case there is…