Questions tagged [aiql]
7 questions
5
votes
1 answer
Check if a value is not in a list in Application Insights Query Language?
Is there a shorter way to check if a property, say user_id is not within a given list:
customEvents
| where user_Id != 123
and user_Id != 234
and user_Id != 345
Mikkel R. Lund
- 2,336
- 1
- 31
- 44
3
votes
1 answer
Azure Application Insights Queries to share the same variable
I have an AI dashboard with a number of queries displaying the last run results. Every query does something like that:
let lastRun = customMetrics
| where session_Id != ''
| top 1 by timestamp desc
| project session_Id;
customMetrics
| where…
marikvntu
- 41
- 1
- 5
2
votes
2 answers
AIQL Application Insights query how to exclude weekends
In some of my reports I'd like to exclude events that happen on weekends as our app is a business application that isn't running on the weekends, yet we do code updates and resulting tests on the weekends that can skew the data.
I've Tried:
and…
crichavin
- 4,672
- 10
- 50
- 95
1
vote
1 answer
Application Insights analytics - Select first value per category
I want do an equivalent of the following SQL query -
(roughly)
SELECT
Name,
application_Version
Rank() OVER (PARTITION BY application_Version ORDER BY CountOfEventNamePerVersion)
FROM
customEvents
Assuming I get the…
Nikhil Girraj
- 1,135
- 1
- 15
- 33
1
vote
2 answers
Row_number() or other analytical functions possible in appinisghts?
I have a pretty simple problem, but I am using appInsights and cant seem to figure out how to replicate row_number() function in aiql or any of the functions (no sense of partition by).
I have pageviews table and I order them by session and…
luckyluke
- 1,553
- 9
- 16
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