How to use the Azure Application Insights tile
The Azure Application Insights tile allows you to query Application Insights for data (both stand-alone and in the context of resources within Azure) and display that information on your SquaredUp dashboard.
SquaredUp executes the requests in the context of the logged in user viewing the dashboard.
The ability to render information as a graph is a feature of the Azure portal rather than the App Insights Query language itself. At this time any queries run using the
render statement will still return tabular or scalar data rather than graphs, depending on the tile.
How to configure an Azure Applications Insights tile
Add a new tile to a dashboard and choose the App Insights tile.
Choose the visualisation for your tile.Scalar
A single value such as a number of customers or incidents.
A table of data, e.g. incidents.
The scope is optional, and allows you to select Azure resources to inject into the query.
For more information see How to scope tiles
Here you determine the timeframe for the search query.
The default timeframe uses the dynamic page timeframe.
Take care when using a long timeframe, as this may pull many thousands of entries and significantly impact browser performance.
If your query doesn't specify a timeframe
Set the timeframe to use page timeframe to make the search query adapt to the dynamic page timeframe or set the timeframe to specific timeframe to choose a fixed timeframe. In this case, the search query will ignore the current page timeframe.What is the page timeframe?
The page timeframe is the timeframe setting a dashboard or perspective is currently using. When a user changes the page timeframe, all tiles that use the page timeframe will adapt to the new timeframe. Tiles that don't use the dynamic page timeframe aren't affected and won't change.
If you are using the page timeframe,you can add a "clamping" timeframe in the query (such as
where timestamp >= ago(7d)). When the page timeframe is less than 7 days it will be used, but once the page timeframe exceeds 7 days the query will enforce the max time.
If your query specifies a timeframe
If you specify a timeframe in the query (e.g.
where timestamp >= ago(2h)), events must satisfy both the timeframe you set here and in the
whereclause in your query.
If you want to control the timeframe using only the query, set the tile timeframe to time range > all.
This is your App Insights application. For more information see What is Application Insights?
It is not possible to query multiple applications on a single tile, because the Azure API in use does not support cross-resource queries.
The tile uses the query language KQL ("Kusto"). KQL is very rich and offers features such as sorting, projection and calculated values, which you can use to control the display of data in your dashboard.
Check out our GitHub Samples repository for sample KQL queries from the community that can be used in Azure tiles.
For more information about writing KQL queries see this external Microsoft article.Query tips and examples for Grids
Example for a performance information request query for a GridCopy
| summarize percentiles(duration, 50, 90, 95) by bin(timestamp, 1h)
Tips for Grid queries
Modify your App Insights query to only return the columns you want to display via
project away. You can hide columns later in the settings, but filtering them directly in the query will improve performance when loading and displaying the tile.
The Azure API in use does not support cross-resource queries.
Configure the settings for your visualisation:Settings for Scalars
Allows you to set the font size of the value in the tile.
Allows you to add a unit to the value displayed in the Scalar tile. For example, if your value shows a time in milliseconds, you can enter "ms" or if your value shows pageviews, you can enter "pageviews".
Allows you to format the value by using the mustache picker. For example, you can round the value up or down or convert it.Settings for Grids
Grid columns opens the grid designer, where you can show or hide columns, change the order of columns, edit column names or add custom columns.
Allows you to turn the graph items (status blocks or icons and the rows of a grid) into hyperlinks that lead you to more information about each item. For example, when you create a status tile for ServiceNow tickets, you can link each icon or block to the corresponding ticket. A click on the icon or block then opens the ticket in ServiceNow.How to find out the format of the URL
Examples for URLs with dynamic mustache properties for popular APIs
Take a look at the URL for a specific object.
For example, the URL to a specific ticket in your system looks like this:
The URL to another ticket in your system looks like this:
This tells you that the URL to specific tickets is always
https://my-ticket-system.com/ticketID-followed by different values. In this case, the value is the ticket ID.
Find the dynamic property in your return data that contains the value you need. You can use the mustache picker to see all the different properties of your return data. For example, if you need to find the ticket ID, the property could be called
Enter the URL with the dynamic property in the URL field:
The URL for each item is now dynamically generated depending on their
Dynamic mustache properties and values you need to change according to your instance are highlighted in bold.
Azure DevOps projects:
Azure DevOps builds:
Azure Application Insights
Show column headers You can choose between showing or hiding the header for all columns.
Click done to save the tile.
The tile now shows data according to your settings.