Build beautiful dashboards with KQL

By Sameer MhaisekarSquaredUp, Technical Evangelist

So you’ve now finally finished putting all the pieces together – transitioned to Azure, deployed resources, deployed applications, got familiar with Azure Monitor and set up all the monitoring. You’re now collecting all the monitoring, application performance and security data for your Azure resources in Log Analytics workspaces, ready for analysis. (Head over to our Azure Monitor Learning Path if you're still figuring out how to do all that.)

But is only the collection enough? To actually implement any meaningful monitoring, you also have to act upon the data collected, and what’s the first step to doing that? You guessed it – visualization!

Sure, the Azure portal offers some useful platform metrics, but in addition, you also have a lot of data in your Log Analytics workspaces, stored in tables. This data can only be extracted using the Kusto Query Language (KQL). Naturally, your next goal now is to look for a way to meaningfully display this data using KQL, that is:

  1. Accessible to everyone (in and outside of Azure),
  2. Easy to make, and
  3. Easy to understand.

SquaredUp comes to the rescue!

Take a look at a sample SquaredUp dashboard, made completely with KQL:

Impressed? There’s more!

Apart from the high-level, bird’s-eye view, generic scoped dashboard like the above, you can also get very personal using SquaredUp’s perspectives.

This perspective here is scoped specifically to the VM you’ve browsed into to display all the VM Insights data being collected and stored for that VM:

Again, all of this is KQL!

SquaredUp dashboards aren’t done just yet. In addition to the dashboards you can create with KQL, you can also plot your platform metrics, view cost information, and connect to any external tools using APIs. Here’s an example of a comprehensive dashboard for an application from multiple aspects:

Interested in knowing more about transforming your Azure dashboarding capabilities?

Check out our Azure portal vs SquaredUp dashboards series.

Or, register below to take a 30-day free trial and see for yourself!

Put Kusto in context with a 30-day free trial of SquaredUp for Azure