Microsoft Azure Operational Insights – Search Data Explorer Cheat Sheet

image

At TechEd Europe Microsoft officially announced Microsoft Azure Operational Insights. If you are not familiar with it check my previous posts about this new “tool”. Behind all these sexy dashboards there is also a very powerful search engine called “Search Data Explorer”. It uses a search window where you can enter a query to get any result you want / need.

The syntax of this query reminds a bit of PowerShell but it was specifically developed for Azure Operational Insights.

An example looks like this…

image

Microsoft offers already predefined queries for all installed Intelligence Packs, so you just need to pick the right one.

For example the Capacity Planning queries look like this…

image

But as always it is better to understand what is going on behind the scenes so that you can customize the result the way you want it. Daniele Muscetta (PM at Microsoft) as written excellent posts how you can build your queries and explains all the possible commands / syntax. You can find the posts here:

    Daniele has written very detailed and long posts which is very useful at the beginning and after you get the idea you just need some sort of notes. For that reason I tried to summarize everything in one single cheat sheet so you can keep it on your desk for reference. It looks like this…

    image

    I hope it provides some help.

    Download the PDF version from TechNet Gallery.

    Update 6.11.2014 Version 1.1:

    • Just eliminated some typos / changed some minor wording

    Update  7.11.2014 Version1.2:

    • Corrected field name Type is case sensitive
    • Added new sample
    • Formatting issues fixed

    5 Comments

    1. Pingback: Grouping and Sorting in Azure Operational Insights Search - Stefan Stranger's Weblog - Manage your IT Infrastructure - Site Home - TechNet Blogs

    Leave a Reply

    Fill in your details below or click an icon to log in:

    WordPress.com Logo

    You are commenting using your WordPress.com account. Log Out / Change )

    Twitter picture

    You are commenting using your Twitter account. Log Out / Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out / Change )

    Google+ photo

    You are commenting using your Google+ account. Log Out / Change )

    Connecting to %s