OMS – Azure Scheduler Solution

Bildergebnis für Azure Scheduler logo

UPDATE 07.08.2017 21:51: I found a bug in the ARM template which made the dashboard not appearing. I fixed it just now, in case you deployed the solution, just redeploy it. Sorry for that hassle.

Currently I am doing some more OMS stuff and therefore I also took a deeper dive at building ARM templates to deploy an OMS solution. I was looking for a simple Azure service to gather data from, which I could ingest into OMS. My goal was, to have a use case, where I only need to provide the minimal parameters necessary and the rest should be done by the ARM template.

How does it work?

Well, basically there is Azure Automation which runs a PowerShell script on an hourly schedule to collect data from Azure Scheduler service. If there are any collections and jobs in Azure Scheduler it will ingest the data into OMS via API.

The OMS solution will contains the following views:

  • Jobs with errors
  • Status of the jobs
  • Jobs and how many times it has been executed
  • How many jobs a collection contains
  • Some useful queries


How do I deploy it?
Go to my


You need to provide the credentials to access Azure Scheduler service, these will be saved in the Azure Automation account. Make sure the credentials have permission to access the subscription you are accessing. In addition you need to provide a schedule link GUID. Because there is no function in ARM template to generate a GUID, we need manually to provide a GUID. This GUID is needed to link the Azure Automation schedule to the Azure Automation runbook. Use PowerShell cmdlet New-Guid to generate a GUID and paste it into to the settings.


The template does the following steps:

  • Creates a resource group
  • Creates an Azure Automation account
  • Deploys the PowerShell runbook / script to collect Azure Scheduler data
  • Creates an Azure Automation schedule to run the runbook to collect the data. It starts every one hour starting at deployment.
  • Creates an Azure Automation variables for OMS workspace and key
  • Creates an Azure Automation  variable for the current subscription id
  • Creates an Azure Automation credential with username and password
  • Updates the AzureRM.Profile and AzureRM.Scheduler modules
  • Installs the OMSIngestionsAPI module
  • Deploys an OMS workspace and installs the solution into the workspace

If you have tried to create such a solution before or any other ARM project, you know, there are many problems you will face.

So what is the current state of this solution?

  • All the necessary components are being deployed and are working (I tested it only in the West Europe Azure location!)
  • There are some parts with the OMS dashboard I need to update and adjust, but for the moment it works and offers a good demo case for an OMS solution.
  • Be aware, it is not a production ready product, it is made for learning and testing. I tested it only briefly and I am not an Azure Scheduler MVP 😉 .

If you encounter any problems or things that don’t appear the way they should, let me know. Have fun!

Power BI – AAD Activity Logs App: The credentials provided for the AADData source are invalid

Power BI used to have Content Packs which were a way to package up your dashboards, reports, Excel workbooks and datasets for Power BI. Microsoft changed it now to so called Apps, probably to be consistent with their Azure terms.

There is an interesting App for Azure Active Directory to analyze the Activity Logs.


If you try to install this App, you need to provide the tenant name and in the next screen you need to authenticate against AAD, but it could be that you receive this error…


The reason was, that I had to switch my Azure Active Directory edition to Premium…


…after this upgrade I the connection worked perfectly and I could analyze my data…


It seems that there is a Premium license required to use this powerful Power BI App. I haven’t found anything on the internet, so I hope it helps you getting this report up and running.

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

SCOM – New SQL Server Management Pack Dashboard Capabilities

3 days ago Microsoft published a new SQL Server management pack version. In every new MP version there are fixes for some bugs or new monitors / rules and support for new SQL Server versions. This MP is a bit different and I would like to spread the words about a very welcome new summer gift. The new management pack contains not only new default SQL Server dashboards (which look btw. awesome!), we actually get the opportunity to use the same kind of dashboard for all groups respectively objects in SCOM.

Just here few impression of the new default summary SQL Server dashboard…


…and if you double click on a tile from the dashboard above, it drills down to a detailed instance dashboard…


There are more default dashboards to explore, but you can also build these kind of summary / detail dashboards yourself! I would like to show a simple example for domain controllers.

Continue reading

NiCE Datacenter Tag 2015 – Session “Operations Manager Dashboards – Neue Widgets und Möglichkeiten”


This blog title looks probably a bit strange to you because it is in German. The company NiCE is organizing a “Datacenter Day” in Munich and there will be all kind of topics presented by Microsoft, partners and people from the community. I will be having a session about the new widgets and its capabilities in SCOM called “Operations Manager Dashboards – Neue Widgets und Möglichkeiten”.

According to Microsoft, 60% of System Center customers are actively using System Center Operations Manager (SCOM) today. While there are many different System Center events available, only a handful of them focus predominantly on SCOM and new products like Azure Operational Insights (OpInsights) for big data analytics. As a leading System Center ISV in Germany, NiCE will be hosting an event in conjunction with Microsoft to address the above mentioned gap. The objectives of the event include:

  • Present and discuss the latest developments and news on SCOM and OpInsights
  • Hands-on tips and tricks for using SCOM in large environments
  • Illustration and recount of the common System Center integration scenarios
  • Present partner extensions for System Center
  • Provide top content in German for the DACH region

The detailed agenda looks like this (subject to change):


If you are interested in attending this event it will held on:

February 17th 2015 at Microsoft München,Konrad-Zuse-Straße185716 Unterschleißheim.

Microsoft Azure Operational Insights – Mobile App Available


I have blogged previously about Microsoft Azure Operational Insights which is still in a preview stage and you can test it free of charge. Microsoft did already a great job visualizing all the data collected by the Intelligence Packs. At this moment you are also able to have all this information on your Windows Phone. The release of the Microsoft Azure Operational Insights Mobile App allows you to look at all the available information on your mobile device.

Continue reading

TechEd Europe 2014 – SCOM Sessions


I wish I could have attended the TechEd Europe 2014 in Barcelona but since I had the chance to go to TechEd NA 2014 in Houston I already got a good picture what is going on. For those who also could not attend TechEd in Barcelona there is luckily Channel 9 who publishes all the session recordings. But there are still some highlights which cannot be recorded like meeting the SCOM product team and of course the networking and community meet ups.


For those of you who also could not attend TechEd in Barcelona here the relevant SCOM sessions on Channel 9:

Introduction to the NEW Microsoft Azure Operational Insights Service with System Center Operations Manager

This TechEd Europe 2014 session covers how Operations Manager as a platform has been extended with Microsoft Azure Operational Insights Preview (previously known as System Center Advisor), a next generation cloud service that provides log collection, search, dashboard visualization and operational intelligence for modern IT operations. Come to this session and see how easy it is to collect machine data/logs and explore them.

System Center Operations Manager: Monitoring in a Modern World

This session illustrates how customer needs for monitoring are changing and how Microsoft is investing in System Center Operations Manager and System Center Advisor to address these updated customer needs.

Building Highly Effective Dashboards in System Center 2012 R2 Operations Manager

This session covers the brand new innovations in the Operations Manager dashboard infrastructure that allows you to build custom dashboards for any audience.

Using System Center for Dynamic Application Mapping

Dynamic distributed applications can make System Center the key to streamlining your IT Operations Programs. Microsoft partnered with BlueStripe to deliver complete, multi-tier application management in System Center. In this session, learn how to deliver: Live, dynamic application discover/mapping, monitoring, and alerting in Operations Manager; Application management across platforms (Windows and non-Windows systems) and architectures (physical, virtual, cloud, and hybrid cloud); and Application management for Azure Hybrid Cloud. BlueStripe automatically discovers, maps, and monitors all the components that make up your distributed applications, regardless of platform or physical location. Learn how to build live dynamic application views that cross Azure and the datacenter, how to use these application maps within System Center Operations Manager, and how to apply application context to provide business services for Service Manager and application performance-focused run books using Orchestrator. You’ll also preview an integration of live distributed application maps into Azure Pack.

Management Pack Authoring for IT Professionals

Monitoring infrastructure is a crucial function in any datacenter. Due to the complexities involved, IT administrators have traditionally either requested services from consultant firms or bought pre-packaged management packs to monitor their infrastructure. Come learn how MP Author, a free management pack authoring tool can be used to create robust management packs that adapt to the needs of your business. Also, come see how MP Author integrates with MP Studio to address the complete lifecycle of a management pack.

Could well be that not all sessions are right now available online but within the next few days they will.