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
4
votes
1 answer

How to monitor Application Event Logs in Azure App Service?

We'd like to monitor the Application Event Logs (the Event Viewer - Application Log in a traditional Windows machine) in Azure App Service. The reason is if our app throws an unhandled exception and crashes during the host start up, IIS log the…
Hengyi
  • 733
  • 11
  • 20
4
votes
1 answer

Should Azure Log Analytics and Application Insights be used per app or per environment?

We have a Azure based system which is growing in complexity, and we need to monitor chains of events and ensure they arrive where we expect them to arrive. We have a on-prem Java application, which sends events to an IoT Hub. The IoT hub routes to…
4
votes
1 answer

Is Azure Log Analytics and App Insights Resilient to DataCenter Failure within an Azure Region

Is app insights and log analytics redundant within a given Azure region (i.e. East US)? In other words, if a single DC within East US goes down, will App Insights and Log Analytics continue to function? If yes, can you provide a link proving this?…
4
votes
1 answer

Reference external data source from AI/Kusto query?

tl;dr: I want to reference an external data source from a Kusto query in Application Insights. My application is writing logs to Application Insights, and we're querying it using Kusto in the Azure portal. To give an example of what I'm trying to…
4
votes
3 answers

Creating Azure Monitor Log Search Alert Rules via Powershell

I'm trying to create some azure monitor rules for the output of log searches, doing this through the web UI is simple enough but I want to automate this through the CLI. Looking through the documentation there doesn't seem to be a way that I can see…
APowell
  • 43
  • 3
4
votes
2 answers

Azure Application Insights with Azure Function. Log Debug not showing up

My Azure function is currently logging to Application Insights. While Logs generated by logger.logInformation line is showing up on Application Insights, logs generated by logger.logDebug line is not showing up. I heard there is a way to temporarily…
4
votes
2 answers

How to write a Kusto query to select only the rows that have unique values in one field

Having this input: let t1 = datatable(id:string, col1:string, col2:string) [ '1', 'col1_1', 'col2_1', '2', 'col1_2', 'col2_2', '3', 'col1_3', 'col2_3', '4', 'col1_4', 'col2_4', '1', 'col1_1', 'col2_11', ]; t1 | distinct id,…
Nicolae Daian
  • 1,065
  • 3
  • 18
  • 39
4
votes
1 answer

How to write a Kusto query to find two consecutive rows that have the same value in a field

I need to write a Kusto query for Azure Log Analysis that finds consecutive events that have the same value in a field (same error code). We basically need to find if the requests fail twice in a row. The case where a request fails, one succeeds…
Nicolae Daian
  • 1,065
  • 3
  • 18
  • 39
3
votes
1 answer

Get Log Analytics Workspace key from Bicep

In a bicep file for an App Service, I want to grab the id and key from an existing Log Analytic Workbench, created in another repo/bicep file. I see this is possible in Terraform, but cannot find any docs on how to achieve this with Bicep, which…
3
votes
1 answer

How do I get the count of messages in a particular Azure Storage queue in Azure Log Analytics

I am trying to get the count of messages in a particular queue from Azure Storage account using Log Analytics to ultimately publish on a dashboard. Thanks in advance for your help
anoopjohn
  • 518
  • 4
  • 18
3
votes
1 answer

Failed to resolve table or column expression named 'SecurityEvent'

I am trying to find security events from Azure log analytics. But its not taking the SecurityEvent keyword. It give the error "Failed to resolve table or column expression named 'SecurityEvent'". // Accounts Failed to Logon // Counts failed…
3
votes
1 answer

Join on multiple columns in KQL (Azure)

How do i create a join query that uses two or more columns? Im trying to do something like this but I cant find any examples on how to join on multiple columns let logMaster = Table1 let logClient = Table1 logMaster | join kind=innerunique…
JensB
  • 6,663
  • 2
  • 55
  • 94
3
votes
2 answers

Show a value only in a dashboard in azure?

I have following query: AppMetrics | where Name=="ReportImported"| summarize Value=count() I would like to show the value in a dashboard, and it looks like this: Is there anyway to only display the number and not having it displayed as a list…
Thomas Segato
  • 4,567
  • 11
  • 55
  • 104
3
votes
1 answer

Difference between Azure App Service logs and Diagnostic settings

I can't find information about the differences in Azure between: App Service logs / Diagnostic settings If someone can explain me in simple words I would appreciate it very much. Thanks !
3
votes
1 answer

Stop ingesting AppDependencies data into Log Analytics Workspace

I have an application that ingests lot of data into Log Analytics Workspace in Azure. I tried to run below Kusto query to figure out which piece is generating and ingesting more data in Log Analytics Workspace. And I found that AppDependencies was…
Aks_M
  • 159
  • 1
  • 9
1 2
3
69 70