Questions tagged [azure-log-analytics]

use for Azure OMS\Log Analytics questions

0
votes
0answers
17 views

Azure VM diagnostics for SQL server not showing in log analytics

I have enabled sql server as part of performance counters. but when I a check log analytics or under metrics or Monitor. I see nothing. does it take time for data to come through? or some more setting ...
0
votes
0answers
29 views

Is there a way to see all resources sending logs to a log analytics workspace?

I know that I can go to "Azure Resources" to view the resources that are connected, but it doesn't list everything that I have set to point to the workspace. For instance, CDN endpoints don't have a ...
0
votes
1answer
22 views

Azure Log Analytics (Kusto) Convert from hex

Is there a way to convert from hex in Kusto? I see a scalar function to convert to hex, but I want to convert from hex. https://docs.microsoft.com/en-us/azure/kusto/query/tohexfunction
1
vote
1answer
28 views

Azure Log Analytics parse WAF data (string data in general)

Trying to parse the below string from Azure WAF logs. Matched Data: \x22:\x22SURVEY_0001\x22,\x22e found within REQUEST_COOKIES:cspSurvey: {\x22surveyId\x22:\x22SURVEY_0001\x22,\x22exit\x22:1} I ...
-3
votes
0answers
33 views

Azure china kubernetes cluster monitoring

Azure Rest of world(.com) Kubernetes service cluster logs can be monitored in Azure log analytics workspace. How can we monitor china azure(.cn) Kubernetes service cluster ? i need to check the ...
0
votes
1answer
16 views

Azure LogAnalytics query for disabled Traffic Manager Profile

I'm looking to query Azure Network/"trafficManagerProfiles events from Log Analytics and more specifically when Traffic Manager Profile is in status Disabled. I've managed to find a specific event ...
0
votes
1answer
41 views

Azure Automation Update Managemet schedules can be removed using powershell, but they still exist in the portal

If I used Get-AzAutomationSchedule for my automation account, I get nothing in return because I used Remove-AzAutomationSchedule for all of them. But if I look in the portal, every schedule I've ...
0
votes
1answer
54 views

Azure - Unable to remove Log Analytics and solution

I’m trying to delete a log analytics and a solution but I’m unable to do it using the portal because of errors. Already made sure that nothing is referencing the log analytics (exception is the ...
0
votes
1answer
24 views

Azure long-term audit log

We have a medical application that requires to store audit logs for 6 years (HIPAA requirement). Looking at the new Azure Monitor service, it seems it will retain information for a maximum of 730 ...
0
votes
1answer
35 views

kusto language pivot 2 columns

I have following query in kusto language: AzureActivity | where ResourceProvider =="Microsoft.Compute" | where OperationName in ('Deallocate Virtual Machine','Start Virtual Machine') | where ...
0
votes
1answer
43 views

How to set color for Columnchart in Azure Data Explorer

I want to render specific requests from my Application Insights as a columnchart using Log Analytics query language: My Query: requests | where operation_Name =="MyOperationName" | render ...
0
votes
1answer
32 views

How do I make my dashboard widget render as a barchart and not a table - Azure Dashboard

I have a custom log query that works fine and renders properly in App-Insights as a bar chart as I have specified. However, when trying to show it on a Dashboard, it only shows the chart data and I ...
0
votes
1answer
29 views

setAzVMextension to connect VM to Log analytics

With the following code I want to connect my VMs to my log analytics workspace. $ResourceGroup ="stackoverflow" $WorkspaceName ="dontberudepls" $AllVMs = Get-AzVM -ResourceGroupName $ResourceGroup ...
0
votes
1answer
33 views

Is there a way to feed IIS logs into App Insights from Log analytics workspace?

We've logs(W3CIISLogs) on Log analytics workspace for websites hosted on VMs. Similarly we have app insights enabled for websites hosted on App service. Now we want to access telemetry data of both ...
0
votes
1answer
16 views

Track Resource deletion from Azure ActivityLog in LogAnalytics

I am trying to alert/visualize Resource changes like creation/deletion of Azure resources using Log Analytics/OMS. I am able to find new deployments using: AzureActivity | where ActivityStatus =='...
0
votes
0answers
22 views

Error while disabling loganalytics alerts [duplicate]

I have written one script which will enable or disable all azure alerts(log analytics alerts) but when ever i am disabling application insight alert its disabling but when disabling alerts created on ...
0
votes
2answers
43 views

PatchResourceNotFound error while calling azure rest API

when i am calling below log alerts azure rest api able to enable/disable only application insights) same api when calling alerts created on log analytics its throwing error "PatchResourceNotFound" ...
0
votes
1answer
47 views

Is there any KQL queries to extract page views, download counts from the W3C IISlogs on Azure-Log analytics?

We're trying to extract page views, file download count, users list from w3c IIS logs. we want to define what's page view, i.e. any user stayed on same page more than 10 sec to be a one page view. ...
0
votes
1answer
54 views

Check if a table exists in Kusto language?

Is there a way to programmatically check if a table is existent in log analytics using the kusto language? For example, let's suppose I want to check if a workspace contains the VMConnection table ...
0
votes
1answer
80 views

Restrict Log Analytics logging per deployment or container

We've seen our Log Analytics costs spike and found that the ContainerLog table had grown drastically. This appears to be all stdout/stderr logs from the containers. Is it possible to restrict ...
0
votes
1answer
50 views

Log analytics query optimization

I run this query on log analytics Perf | where TimeGenerated >= ago(5m) | ...
0
votes
1answer
40 views

Possibilities of tracing REST trace time with azure log analytics similar to zipkin

We are in process to keep all monitoring and logging stuff outside of AKS. we got some success with Azure log analytics as well. I am checking if Azure log analytics provide any feature similar to ...
0
votes
1answer
33 views

Create Azure SQL Analytics via Powershell

I'm wondering if there is a specific Powershell command to create Azure SQL Analytics resource. So far I've only found how to enable sending diagnostics logs to a Log Analytics workspace. I assume I ...
0
votes
1answer
86 views

How to delete custom log created by Log Analytics Data collector API

How can i perform delete operation on custom log in azure log analytics ? ex : DemoExample_CL I can delete it when create one in Advanced settings>Data>Custom Logs, but when i use "Log Analytics Data ...
1
vote
1answer
55 views

Pushing logs to Log Analytics from Databricks

I have logs collected in Databricks cluster but I need to pushed to Log Analytics in Azure to have a common log collection Have not tried anything but would like to know what the approach
1
vote
0answers
38 views

Azure B2C enabling diagnostic logs to integrate with log analytics asking for subscription, even though tenant is already liked with a subscription

I am trying to integrate B2C with Azure log analytics. Based on this link https://docs.microsoft.com/en-us/azure/active-directory-b2c/active-directory-b2c-reference-audit-logs logs will be written to ...
1
vote
2answers
137 views

Querying Log Analytics So That It Returns a List of All Table Names

I am using Python to call queries against my Azure Log Analytics Workspace. In order to provide maximum scalability, I would like to implement a query which returns all table names within my Log ...
0
votes
2answers
85 views

Azure Log Analytics - Alerts Advice

I have a question about azure log analytics alerts, in that I don't quite understand how the time frame works within the context of setting up an alert based on an aggregated value. I have the code ...
0
votes
2answers
99 views

How to connect Azure Activity Monitor to Log Analytics Workspace via ARM template

How do I connect Azure Activity Logs to a Log Analytics workspace using an ARM template? I can connect it via the portal: Or using powershell. But I've searched far and wide and can't find ...
0
votes
1answer
72 views

Selected Logging and Sampling Rate with Application Insights for both Azure APIM and Azure Funtions

I have a project that is hosted via Azure Function app, and sits behind APIM. One of the requirement is to log all successful and failed login requests from both APIM and Function. Application ...
-1
votes
1answer
37 views

What fields are included under AllMetrics for Log Analytics for Azure Functions 2.x

I want to find out what fields are included for the AllMetrics checkbox shown below for Log Analytics for Azure Functions 2.x. Links to MS official website is required. Thanks in advance.
0
votes
1answer
113 views

Can we query blog storage log in Azure Monitor Logs?

My application stores logs in blog storage as that is the setting in App Service. My understanding is there are IIS logs in app service and they go to the blob storage as well. A)Here it is mentioned ...
-1
votes
1answer
76 views

Unable to link existing workspace in Azure log analytics

I'm not able to link my any of the existing log analytics workspaces to the log analytics service. Its showing "It looks like you have no workspaces to link".
0
votes
1answer
39 views

Azure Log Analytics Aggregation Query

I am having trouble creating with the below query. I am trying to get the average number of sessions from four computers over a time interval of one hour. I then want to chart the sum of the four ...
0
votes
2answers
50 views

Error setting up Azure Function within Azure Resource under Log Analytics Workspace

I have error setting up Azure Function within Azure Resource under Log Analytics Workspace. When only AllMetrics is checked, it works. But whenever FunctionExecutionLogs is checked, error occurs like ...
0
votes
0answers
72 views

Summarizing funnels by customDimensions in Azure Log Analytics

I made a funnel in AI (customEvent1 to customEvent2), it gives me a before, after number and percentage. But I would like to summarize it by customDimension. let allEvents=customEvents | where ...
0
votes
1answer
68 views

Adding Where condition on Timestamp yields odd aggregated results

I'm looking into Azure Monitor queries for the first time, and can't understand why adding this line: | where timestamp <= ago(1days) makes the query results "de-aggregated." Screenshots of ...
0
votes
1answer
108 views

Setting up data and options used by Azure Log Analytics with API Management

I have questions on using Azure Log Analytics for API Management. I cannot find more information on Azure Log Analytics with API Management. Questions What data is Log Analytics based on by default? ...
0
votes
2answers
62 views

Azure Log Analytics - Numeric Custom Field Plot on Chart

I am looking to get statistics on people logged onto a Remote Desktop Application pool within a date range. I have created a powershell script which counts the number of sessions for a specific ...
0
votes
1answer
29 views

Delete Azure Log Analytics solution after Workspace was deleted

I had an Azure Log Analytics Worspace with two Solutions and I deleted the Workspace without deleting the Solutions. Now when I try to delete the Solutions I'm getting an Unknown error from the portal....
0
votes
1answer
53 views

Is azure TenantId equivalent to azure log analytics WorkspaceId?

I'm trying to get from azure some information about computers. What I want to get back is the list of Azure wokapceId, SourceComputerId, Resource group for each machine. I used the ...
1
vote
2answers
337 views

Azure application insights or log analytics

What is the use case for Azure application insights or log analytics? I am using APIM and Azure Functions, and want to perofrm loggings for request, which one is best fit, application insights or log ...
0
votes
0answers
93 views

Azure loganalytics python SDK always throws MissingApiVersionParameter exception

I try to follow MS official doc to get the log from my resource in Azure Log Monitor but never success. My code is like below. from azure.loganalytics import LogAnalyticsDataClient from azure.common....
0
votes
1answer
68 views

What is the name of the Agent to connect a Linux server to Azure Log Analytics Workspace?

I have the need to send my logs to Azure for my custom product. The users of my product can decide what to do (if anything) with these logs. I created a Log Analytics Workspace in the Azure Console....
0
votes
1answer
61 views

Problem seeing custom application log in Azure Log Analytics

I have an Azure Linux VM running a custom product. I want to upload the logs to Azure. At this point I just want to save the logs in Azure, but at a later date I will possibly scan the logs for ...
0
votes
0answers
136 views

Kusto queries render function ignores specified Y range

I'm having a problem with the analytics tools, specifically the Analytics inside Application Insights as well as the Logs analytics inside a Log Analytics workspace. Regardless of query or chart type,...
0
votes
1answer
104 views

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 ...
0
votes
0answers
117 views

Azure Log Analytics REST API returns 502 (Bad gateway) error

I have a function that queries the Log Analytics Batch endpoint (https://api.loganalytics.io/v1/$batch) ~450 times a day, out of which ~60 requests return a 502 Bad Gateway. It is always the same ...
0
votes
1answer
338 views

How to transform a JSON array of objects to a Kusto table?

I have a JSON schema that I get from the server and I need to transform this JSON into a log analytics query language table and use that table to make a join with another table. The JSON has the ...
-1
votes
1answer
40 views

How to connect Log Analytics to Office 365 after the OMS portal is over

Previously I used OMS portal to connect Office 365 to Log Analytics. However, I do not know how to connect after OMS portal is discontinued. Is there a way to connect Log Analytics to Office 365?

http://mssss.yulina-kosm.ru