Stack Overflow
Stack Overflow

Questions tagged [ms-app-analytics]

In relation to the analytics feature of Application Insights. The query language, chart generation, integration with other tooling ant the API.

Analytics in Application Insights

Analytics is the powerful search feature of Azure Application Insights. These pages describe the Analytics query language:

58 questions
0
votes
1 answer

Data point values listed as 'OTHER' in rendered charts, but Table shows expected values

I've been working with App Insights Analytics chart tooling and noticed that a sizable portion of rendered chart data points have a listed value of 'OTHER'. However, when I look at the Table data all columns and data points contain the expected…
Jordan
  • 639
  • 1
  • 13
  • 30
0
votes
1 answer

Avoid running a function multiple times in a query

I have the following query in Application Insights where I run the parsejson function multiple times in the same query. Is it possible to reuse the data from the parsejson() function after the first invocation? Right now I call it three times in the…
Praveen Reddy
  • 7,295
  • 2
  • 21
  • 43
0
votes
2 answers

app insights analytics auto run query and email results

I've created some queries in app insights analytics that produce tabular data. I'd like to run these queries once a day and email (or Skype or Slack if easier then email) the results to various people. Is there a built in way to do this, or do I…
Slicc
  • 3,217
  • 7
  • 35
  • 70
0
votes
2 answers

Alert on error rate exceeding threshold using Azure Insights and/or Analytics

I'm sending customEvents to Azure Application Insights that look like this: timestamp | name | customDimensions ---------------------------------------------------------------------------- 2017-06-22T14:10:07.391Z | …
madd0
  • 9,053
  • 3
  • 35
  • 62
0
votes
1 answer

Application Insights Analytics - Chart X axis

How can I render a chart for the query performanceCounters | where name == "% Processor Time" | summarize avg(value) by bin(timestamp, 5s),cloud_RoleInstance where i get a point for every 5 seconds and not every 1 min?
Leonardo
  • 10,737
  • 10
  • 62
  • 155
0
votes
1 answer

Application Insight Analytics Pivot

Is there a way to pivot in Azure Application insight analytic queries? SQL has a Pivot Keyword, can similar be achieved in Application insight Analytics? When I run the below query I get exceptions and count, but I would like to see a day on day…
Shiju Samuel
  • 1,373
  • 6
  • 22
  • 45
0
votes
1 answer

Substitute variable name in a dynamic json property

I would like to use the variable settingName for the dynamic json property. How can i accomplish that? let settingName = 'LaunchNext'; DSEvents | where Timestamp > ago(1d) and Data contains (settingName) | summarize count() by…
Praveen Reddy
  • 7,295
  • 2
  • 21
  • 43
0
votes
1 answer

how to read attribute from json

I want to read values of a json (message) object which has array in it. This below query helps for immediate properties in d. traces | extend d = parsejson(message) | d.Timestamp, d.Name; How do I read property part of an array within d…
Praveen
  • 166
  • 2
  • 4
  • 13
0
votes
1 answer

How to get total number of site visits (Region wise) using Application Insight Analytics in Azure portal?

I have used below query to get the total number of requests by regions in last 30 days. requests | summarize count_=sum(itemCount), avg(duration) by bin(timestamp, 1h), client_StateOrProvince, client_City | order by timestamp asc,…
kudlatiger
  • 3,028
  • 8
  • 48
  • 98
0
votes
1 answer

Extract time portion out of Timestamp

I am using Azure Application insights and would like to extract just the time portion out of Timestamp. For ex: Input : "2017-01-23T20:00:00.2804261Z"; //This is a Timestamp data type Output : 20:00:00.2804261Z
Praveen Reddy
  • 7,295
  • 2
  • 21
  • 43
0
votes
2 answers

What is the conventional way of checking whether something Exists in another table in Application Insights Analytics Query Language?

I want to limit requests by a specific associated dependency by name. I tried using a leftsemi join but that didn't seem to work as I expected because it game me the same results as my inner join. requests | where timestamp >= ago(24h) | join…
jpierson
  • 16,435
  • 14
  • 105
  • 149
0
votes
1 answer

Using application insights REST API for reading custom events

We have a custom event put in place on page which tracks the link clicks on given page to app insights. And with the REST API we would like to get the frequently accessed links from app insights. How can we build the Query to get this analytics…
Padmaja
  • 31
  • 4
0
votes
2 answers

Application Insight Request Region

I have a application which is hosted in multiple regions in Azure. Lately customers are complaining about slow performance. We are suspecting the issue is in one of the Azure regions, I am trying to look at the analytics from AppInsight and I could…
Shiju Samuel
  • 1,373
  • 6
  • 22
  • 45
1 2 3
4