Insights Lab Application Insights Analytics Widget

Application Insights Analytics widget runs arbitrary queries and outputs results in different formats

Learn more about Application Insights Analytics

Features

Runs pre-configured Log Analytics queries against Application Insights
Per-user configurable cache
Outputs in three formats - scalar value, table and timeline chart
Larger view (lightbox)
Storing query text in VSTS version control
Arbitrary widget sizes

Example

Setup instructions

The widget setup requires entering data in all configuration fields.

Application ID and Access Token are required. They can be obtained from azure portal

After entering data, click "Run" under the command field and the widget will try to log in and execute the query - you should see the results.

Result rendering looks at the data returned to determine the display mode. There are 3 display modes - scalar, tabular and time series.

Scalar: the query must return one row and one column as a result (use limit and project commands). Depending on data size, this is best displayed at 1x1, 2x1, 3x1 etc widget size

Tabular: by default the data is shown in tabular form

Timeline series: there are two ways to trigger this mode

Use "render timeseries" command in the end of your query - first non-number column is used as series. If only numeric columns are present, the column names are used as series.
Have query return datetime and numeric value as first two columns ( you can return more numeric columns after that for additional series). Use project to set up the query in that format. E.g. "| project TIMESTAMP, numericcolumn1, numericcolumn2"

Additional features

Full screen dialog with zoomed in view (lightbox) opens when clicking on the chart or on the table, or using dedicated lightbox button

Widget can read the command text from version control - check the VC checkbox and select the file using file selector

Widget caches the data using various strategies - the command text is used as cache key, so any change to the command invalidates the cache

Limitations / known issues

render command is only interpreted for "timeseries" type of chart

Contributors

We thank the following contributor(s) for this extension: Artem Saveliev.

Feedback

We need your feedback! Here are some of the ways to connect with us:

Add a review below

Send us an email on support link to the right