Azure Operational Insights Book Configuration Reporting

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

    6 Replies to “Microsoft Azure Operational Insights – Search Data Explorer Cheat Sheet

    Leave a Reply

    Your email address will not be published.

    This site uses Akismet to reduce spam. Learn how your comment data is processed.