This Concludes My Year 2014

It is one day away from the holiday season of the year. And I have worked HARD over the last few days so I can post my last technical post for the year 2014 before holidays. First of all, I’d like to wish everyone a Merry Christmas and Happy New Year! 2014 has been a fantastic year for me. Here are some of the highlights for me in 2014: I’ve been awarded as a Microsoft System Center Cloud and Data Center Management MVP for the first time in 1st July 2014. This is truly my biggest accomplishment of the year.

A SMA Integration Module For SharePoint List Operations

Background Many Microsoft System Center Orchestrator and Service Management Automation (SMA) users may agree with me, that these two automation platform does not have feature rich end user portals natively. Although System Center Service Manager can be used as a user portal for triggering SCORCH/SMA runbooks, Microsoft SharePoint is also a very good candidate for this purpose. Integrating SharePoint with Orchestrator and SMA is not something new, many people have done this already. i.e. System Center Universe America 2014 – Orchestrating Daily Tasks Like a Pro (by Pete Zerger and Anders Bengtsson) Service Management Automation and SharePoint (by Christian Booth

Using Royal TS for PowerShell Remote Sessions

Background I have used many Remote Desktop applications in the past. I have to say Royal TS is the one that I like the most! Recently, I showed it to one of my colleagues, after a bit of playing around, he purchased a license for himself too. Today, my colleague asked me if I knew that Royal TS is also able to run external commands, and he thought it’s pretty cool that he’s able to launch PowerShell in the Royal TS window. Then I thought, if you can run PowerShell in Royal TS, we should be able to establish PS remote

A Free Management Pack Catalog for Everyone

In the 2 most recent post, I have blogged my experience setting up a Microsoft OpsMgr MP catalog using SharePoint and SMA. I managed to produce 2 versions: On-Premise Version: Using SharePoint 2013 and SMA (System Center Service Management Automation) Off-Premise (Cloud) Version: Using Office 365 SharePoint Online and Azure Automation As I mentioned at the end of the second post, I was working with my SCCDM MVP friend Dan Kregor to create this MP catalog on Sparq Consulting’s public SharePoint site – Free for everyone. I am pleased to announce, everyone can now access this catalog from this URL:

Using Azure Automation to Build Your Own Microsoft OpsMgr MP Catalog on SharePoint Online

Background Previously, I have posted how to build your own Microsoft OpsMgr MP Catalog on SharePoint 2013 using SMA. It is a solution that you can implement on-prem in your own environment if you have existing SharePoint 2013 and SMA infrastructure in place. As I mentioned at the end of the previous post, I have also developed a solution to populate this MP catalog on a Office 365 SharePoint Online site using Azure Automation – a 100% cloud based solution. Because of the differences in APIs between on-prem SharePoint 2013 and SharePoint online, one of the runbooks is completely different

Using SMA to Building Your Own Microsoft OpsMgr Management Pack Catalog On SharePoint 2013

Background Over the years that I’ve been working with OpsMgr, for me, the Microsoft Pinpoint MP Catalog was a one stop shop for getting Microsoft management packs. More information about the Pinpoint MP Catalog can be found in Marnix’s post: Based on the information came out in TechEd Europe 2014, looks like there will be changes introduced to the System Center Pinpoint site (, from 09:00 onwards). And it seems the link from Marnix’s post is no longer valid. So I’ve decided to do some experiment, see if I can generate and maintain a Microsoft MP catalog on-premise,

Using the SendEmail SMA Integration Module in Azure Automation

Over the last couple of days, I’ve spent sometime on Azure Automation (SMA in Azure). The first thing I did was imported and configured the SendEmail and SendPushNotification SMA Integration Modules that I have posted earlier. I created a simple test runbook to send an email and a push notification to my android phone:

However, I found 2 issues related to the SendEmail module. I’ll go through both of the issues in this post. Issue 1 When I executed this runbook, it failed to send the email message. I got this error: Cannot find the ‘Send-Email’ command. If this

%d bloggers like this: