Stack Overflow
Stack Overflow

Questions tagged [azure-analytics]

36 questions
5
votes
4 answers

Convert UTC 'TimeGenerated' to local time in Azure monitor/log/analytics, when using "summarize by"

I have this simple query MyLog | summarize avg(executionTimeInMS_d) by bin(TimeGenerated, 5min) I'd like the summary to be in my local time zone, not UTC. This does not work : MyLog | summarize avg(executionTimeInMS_d) by bin(TimeGenerated-5,…
Greg Bala
  • 3,563
  • 7
  • 33
  • 43
3
votes
1 answer

Find the start and end time (or time span) of the kusto query is running on azure log analytics?

I am struggling here to find the time interval over which the kusto query is being run. What I am trying to do is to calculate the downtime of some specific API's which are running on Azure app service. All the logs of the azure APP service are…
Abhijit
  • 631
  • 7
  • 13
2
votes
1 answer

ADF- Define dynamic triggers

I created a scheduled trigger which executes an ADF pipeline in our development environment. The trigger runs at 4AM on a daily basis. I now want to release this process into our test ADF environment but the trigger should kick of at 6AM on a daily…
user3298593
  • 115
  • 1
  • 13
2
votes
3 answers

How to track Azure work items that have been added into the sprint after the iteration start date?

Folks, First of all, this question is based on the premise that I´m connecting Azure devops data through the Analytics View and all fields available were selected to the view. I want to track whether the development team stuck to the plan or worked…
André Kroker
  • 23
  • 3
2
votes
1 answer

Azure Stream Analytics reference input cannot read from Storage blob

We are trying to create a Storage reference input for Azure Stream Analytics job and all the configuration and the test goes well, however when we try to use it in a Query, we get the following messages in the portal UI: "While sampling data, no…
toddysm
  • 598
  • 3
  • 5
  • 15
2
votes
1 answer

Azure analytics kusto queries : how to group by 2 conditions?

I am using Azure analytics for a mobile app. I have custom events for main app pages - that I can find inside the customEvents table. I am very new to kusto, so using the samples I found the following query: let start = startofday(ago(28d)); let…
Codrina Valo
  • 433
  • 1
  • 5
  • 14
2
votes
0 answers

Azure Timezone difference: Application insights vs Diagnostic

Timezone in Diagnostics is displayed as UTC by default but cannot find a way to configure. Timezone in Azure Analytics (query) can be configured and is by default UTC Timezone In Application insights however is local time(of who ever uses it)…
Blue Clouds
  • 7,295
  • 4
  • 71
  • 112
1
vote
2 answers

Is there any Lync Services or connectors available for Azure Sentinel or Azure Log Analytics to connect Azure Data Factory

I need to pull the data from Azure Sentinel in an Incremental manner. E.g: step 1: Need a daily login details to my UI from Sentinel(using KQL) step 2: create a pipeline from ADF step 3: Load the data in tables Is there any Lync Services or…
subham das
  • 9
  • 1
1
vote
1 answer

Azure DataFactory - A database operation failed with "Invalid object name"

I have a Data Factory datasets where the connection is working, but when I try to "preview" the table structure I get the following error: Error details Error code 22301 Details A database operation failed with the following error: 'Invalid object…
Cornel Verster
  • 1,664
  • 3
  • 27
  • 55
1
vote
2 answers

How to access an azure Database containing data from Azure Log Analytics Query

I have a working query for my app data to be analyzed. currently it analyzes the last two weeks data with an ago(14d). Now i want to use a value containing the release date of the apps current version. Since i havent found a way to add a new…
Maverick1st
  • 3,774
  • 2
  • 34
  • 50
1
vote
2 answers

Send custom complex properties to Telemetry to Azure Portal with App Insights TrackEvent in Javascript?

How can I send custom complex non-string properties to Telemetry to Azure Portal with App Insights TrackEvent in basic Javascript (not NodeJS)? I initialized the Application Insights JavaScript SDK through the following setup snippet:
Florin Vîrdol
  • 395
  • 2
  • 10
  • 28
1
vote
1 answer

Measuring DevOps KPIs like Deployment Speed, Deployment Failure Rate and Time to Recover with AzureDevops?

I'm trying to create an Azure DevOps dashboard for a project with below KPIs. Lead Time Deployment Speed Deployment Failure rate Time to recover These KPIs are not available in Azure DevOps by default except for the Lead Time. Azure DevOps…
sumeda
  • 13
  • 2
1
vote
1 answer

Best practice about the frequency of sentiment analysis in Azure Text Analytics

In my asp.net application, I want to do a sentiment analysis on each discussion forum item as they are posted by the users. I wonder if it is a good practice to make a request to Azure Text Analytics server to do a new Sentiment Analysis each time a…
renakre
  • 8,001
  • 5
  • 46
  • 99
1
vote
1 answer

Querying from multiple application insight across tenants

We are migrating one application from one resource group to another resource group which is on a different tenant. We are using application insight custom event to log custom data and using that data in a power bi Report using app insight analytics…
Smruti Ranjan Mishra
  • 31
  • 6
1
vote
1 answer

How to access the range-step value within `toscalar()` statement used within `range()` statement

Am using a Kusto query to create a timechart within Azure AppInsights, to visualize when our webservice is within its SLO (and when it isn't) using one of Google's examples of measuring if a webservice is within its error budget: SLI = The…
Grumpy Curmudgeon
  • 117
  • 6
1
2 3