OMS – Log Search Cheat Sheet


A bit more than 2 years ago I created a cheat sheet for Azure Operational Insights Search Data Explorer, today known as Operations Management Suite (OMS) Log Search. Over the years this technology has evolved and grown to one of THE most exciting products from Microsoft. The log search syntax has also grown and got some new options. Because of that, I updated the legacy cheat sheet to meet the latest syntax and modified the examples. I had to extend the sheet to two pages, so that the content would make sense.

Page 1…image

…Page 2


Continue reading

SCOM 2012 R2 – SQL Server 2014 / Report Viewer 2014 Support

Microsoft announced few month ago SCOM 2012 R2 offers support for SQL Server 2014…


And if we go to the TechNet article it also clearly says, SCOM 2012 R2 is supported on SQL Server 2014 here described


There is even a perfect table which explains everything clearly…


From my point of view, this let’s us assume, that we can just pick SQL Server 2014 and used it for a clean installation of SCOM 2012 R2. In this TechNet article we find even this sentence…

Use this information to evaluate if your SQL Server environment is ready to support the installation of or upgrade to System Center 2012 R2. Use this information whether you are deploying one or multiple components of System Center.


So there is no doubt, that it is fully supported to install a clean installation of SCOM 2012 R2 on SQL Server 2014.

Continue reading

Power BI – Introduction Part 1

I had already written in the past, that I like to combine new technologies to build new solutions. There are new technologies coming which might get not that attention yet they would deserve. My recent attention got caught by Power BI. I had some sort of idea what Power BI would be but not in detail so I did some research to get a better picture. My intension is to give you a brief idea what Power BI for Office 365 and Power BI is, because I will do some future blog posts on Power BI and will refer to this post. Power BI for Office 365 will not be my focus, because it is somewhat “old” and too tight up.

Microsoft Power BI is a collection of online services and features that enables you to find and visualize data, share discoveries, and collaborate in intuitive new ways. There are two experiences now available for Power BI: the current experience, generally referred to as Power BI for Office 365, and a new experience for Power BI, currently offered as a public preview.

So there are TWO Power BI thingies out there.

  • Power BI integrated into Office 365
  • Power BI (I call it “standalone”)

The Power BI for Office 365 version is the older and probably more known version of the Power BI family, than the new Power BI version which currently is in a preview version available. So what are the main differences?

Continue reading

Microsoft Azure Operational Insights – Search Data Explorer Cheat Sheet


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.

    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

    SCOM – Role Permission For Scheduled Reports

    Depending on the SCOM role you are using you might need to give the user the ability to see and run scheduled reports. For example you add the user into the SCOM Operator role in addition you create Report Operator role and you assign this Report Operator role permission for Reporting Services. Marnix Wolf has written a great blog post about assigning permission for Report Operators.

    Usually you assign the permissions MyReports and Browser to run reports. The problem is that you won’t see the scheduled reports.

    Continue reading

    SCOM – SCOM Console Empty Report Pane

    Today I bumped into an interesting issue. The customer needed to restrict access to the SCOM environment a SCOM Operator role and in addition access to the SCOM reports in the console. Therefore I created the SCOM Operator role with the needed permission and I also created a Report Operator role and added the user into both roles. Just to point out, the role permissions in SCOM are cumulative, meaning the sum of permissions is the final permission for that user. Finally I tested it with the customer and found an empty reporting pane like this…


    If you are familiar with the reporting functionality, you know that reporting is communicating over http (port 80) or https (port 443). In my case it was configured to use http.

    So I started troubleshooting…

    Continue reading

    SCOM – SQL Server Event ID 28005, AEM Wizard Runs Forever, Reporting Services Not Working

    I like to automate things, creating batches and scripts. Well at least I like to create them myself and then I know what they do. In a small project I needed to install SCOM 2012 SP1 to show Agentless Exception Monitoring. Because larger environment need a managed way to install IT systems identically they often use some sort of preconfigured deployment or configuration script. I don’t like this kind of configuration, because as a consultant you never now what is going to happen in the background and you will run into trouble especially if it is something more difficult like SQL server.

    For the SQL Server installation I used a batch file with preconfigured settings from the company to deploy SQL Server 2012 SP1. Everything worked fine and also the SCOM 2012 SP1 installation ran fine until I needed to install the reporting part.

    Continue reading