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…
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…
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…
I hope it provides some help.
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