Questions tagged [azure-log-analytics]

Use for Azure Monitor Log Analytics questions (was: OMS)

Azure Monitor Log Analytics is a service in Azure that monitors your cloud and on-premises environments to maintain their availability and performance (used to be known as Operations Management Suite - OMS). It collects data generated by resources in your cloud and on-premises environments and from other monitoring tools to provide analysis across multiple sources. This article provides a brief discussion of the value that Log Analytics provides, an overview of how it operates, and links to more detailed content so you can dig further.

1047 questions
2
votes
1 answer

Azure Log Analytics Query with WHERE clause produces no results

I'm querying log entries in Azure Application Insights originating from AppCenter Diagnostics using Azure Log Analytics. In some log entries i use custom propertys. Now i'm trying to write a query to show values only with certain properties having a…
2
votes
2 answers

Kusto: How can I get the value from the column that doesn't participate in a SUMMARIZE?

Having the below table and Kusto query, how can I obtain a result that has the Purchase column? let ProductsTable = datatable(Supplier: string, Fruit: string, Price: int, Purchase: datetime) [ 'Contoso', 'Grapes', 220, datetime(2018-10-01…
Nicolae Daian
  • 1,065
  • 3
  • 18
  • 39
2
votes
1 answer

Azure Log analytics simple pie chart

I have a query like; example_CL | where field1 == "name" | top 1 by TimeGenerated desc Gives me the latest row with the latest value of "name" like; name quota used samplename 100 75 I'm trying to make a donut chart which shows…
DynamicQ
  • 115
  • 2
  • 5
  • 11
2
votes
2 answers

Querying Azure Log Analytics from C# application

I am struggling for the past few days to query custom logs from Azure Log Analytics. I've been following the tutorial provided by Microsoft from https://dev.int.loganalytics.io/documentation/1-Tutorials/Direct-API but I keep getting 403. I granted…
2
votes
1 answer

Determine retention period set on Azure Log Analytics workspace

Is there a way to determine the data retention period set on an existing Log Analytics workspace?
phydeauxman
  • 1,432
  • 3
  • 26
  • 48
2
votes
3 answers

How to rename axes in Azure Log Analytics Timechart Query

I have the following query that I want to change the name of the axes. I tried the optional attributes of render, but it doesn't seem to recognize any of them. What am I missing? AzureStorage_CL | where ResourceGroup == "rg-sdl-adw" | where…
SPSamL
  • 158
  • 1
  • 12
2
votes
0 answers

Creation of Multiple Alerts for Azure Log Analytics and Metric based Criteria using Azure PowerShell?

Supposed that I have prepared one common template file for Azure the creation of Metric based Alerts, and have 2 separate parameters file for 2 different metric alerts (e.g. CPU utilization, Memory Usage). Please refer to my example of template…
Charlie Kee
  • 1,161
  • 3
  • 11
  • 26
2
votes
0 answers

The api-version '2016-07-01' used to deploy the template does not support 'SubscriptionId' property

Am working on ARM Templates and using VSTS for to deploy them. Here using ARM Templates, I want to deploy Azure Kubernete Service in to my portal. The deployment is successfully while deploying them in local using PowerShell, but when am tried to do…
2
votes
1 answer

Writes to Azure's Log Analytics Data Collector API return with 403. Worked fine yesterday

The following code uses com.google.code.gson.gson:2.8.5 and org.asynchttpclient.async-http-client:2.5.2 to send JSONs to Azure's Log Analytics. It worked fine until yesterday midnight, but then suddenly started returning HTTP 403 responses. What…
Malt
  • 28,965
  • 9
  • 65
  • 105
2
votes
1 answer

Azure Load Balancer Log Analytics

I have an Azure Load Balancer, I have gone into the Load Balancer resource, Diagnostics logs and ticked 'Send to Log Analytics' and set to my Azure Log Analytics OMS Workspace. But when I go into the Log Analytics and run: AzureDiagnostics | where…
Jeffrey
  • 2,095
  • 3
  • 20
  • 36
2
votes
2 answers

Azure Log Analytics - IIS Log (W3CIISLog) Not Captured

We have installed the Microsoft Monitoring Agent on window server to capture IIS Logs; at the OMS Data Settings have enabled the "Collect W3C format IIS log files". But at the Log Analytics cannot seeing any IIS logs is appear. Any idea on this.
Ong Yao
  • 21
  • 3
2
votes
2 answers

Azure Log Analytics. Create Alert Rules with ARM Template

I'm trying to create Alert Rules with ARM Template. However when I deploy the example found in documentation it reports success but doesn't seem to create any alerts. The template I'm using is the same as in documentation at it is: { "$schema":…
WinBoss
  • 879
  • 1
  • 17
  • 40
2
votes
0 answers

Azure Log Analytics Getting IOPs

I'm trying to find the Avg. Disk sec/Write and Avg. Disk sec/Read on disks in azure using log analytics, but I keep getting errors. I'm reluctantly trying OMS as I haven't found a way to get the information through Powershell. Is there a way on…
Norrin Rad
  • 881
  • 2
  • 18
  • 42
2
votes
2 answers

App insights: how can i get first 'details' column in the 'problemId' group

I have this query a count by problemId of the exceptions in App Insights: // exception count by problem ID let start=datetime("2018-01-09T14:17:00.000Z"); let end=datetime("2018-01-10T14:17:00.000Z"); let timeGrain=5m; let dataset=exceptions //…
2
votes
1 answer

Azure Log Analytics - Query Application Insight Custom Metrics

I have an Azure Application Insight component and separate Log Analytics component which pulls data from App Insight. Inside Log Analytics portal, Using Log Analytics query language (power query), I can get Application Insight Traces and Custom…