System Center Orchestrator 2012 Beta: Creating an overview of RunBooks using Orchestrator Web Service and PowerPivot For Excel

In my opinion, one of the greatest improvements in Orchestrator compared to Opalis is the extended web service.

Opalis did have a web service too, but the Orchestrator service has a more functionality.

One way to utilize this new web service is by using PowerPivot for Excel.

PowerPivot for Excel is an addon developed and published by Microsoft. You can read more and download a trial here

using PowerPivot for excel , it is possible to connect to all different types of data sources and create real-time reports.

It is really easy to do, specially with a web service like the one Orchestrator offers.

  • Open Excel 2010 and start with a blank workbook.
  • Select the “PowerPivot” Ribbon tab.
  • Click “PowerPivot Window”

image

  • Click “From other sources”

image

  • Select “Other Feeds”

image

image

  • Click Next. if you want to test the connection first, click “Test connection”
  • Select what you want for the report. In this case we are making an overview sheet of the RunBook. therefore select “RunBooks”.

image

  • Click Finish, now you should get a result similar to this

image

  • Now you have a complete list of all runbook. In this demo setup I only have one, therefore my list if pretty short 😉

image

  • Select All and copy it into the Excel Sheet. You have other options too, experiment a little with PowerPivot.
By | 2011-08-08T09:00:00+00:00 August 8th, 2011|Automation|3 Comments

About the Author:

Jakob Gottlieb Svendsen

Twitter: @JakobGSvendsen

Jakob Gottlieb Svendsen is a Microsoft Cloud and Data Center Management MVP (http://mvp.microsoft.com/en-us/default.aspx), Working as Global Lead Developer, Senior Consultant and Trainer at CTGlobal, where he is one of the driving forces in keeping CTGlobal a System Center Gold Partner and member of the System Center Alliance.

Since he started at Coretech in 2007, he has focused on Scripting and Development, primarily developing tools, extensions and scripts for the System Center Suite. His main area is Automation (including OMS/Azure Automation, Service Management Automation, PowerShell and Orchestrator). Another area is Windows Azure Pack / Azure Stack, where he does implementation, development, workshops and presentations. He is a world-wide renowned voice in the Automation field.

He is passionately devoted to the community, to which he contributes by being a moderator at TechNet and sharing his knowledge at http://blog.ctglobalservices.com/jgs

  • Co-founder: PowerShell User Group Denmark
  • Speaker at MMS 2016, Minneapolis (www.mmsmoa.com)
  • SCU Europe 2014, 2015, 2016 (www.systemcenteruniverse.ch)
  • Microsoft TechEd North America 2014, Houston
  • NIC 2012,2013,2014,2015, Oslo (www.nic.com)
  • Microsoft CampusDays 2011, 2013, Copenhagen
  • Microsoft TechDays 2015, Sweden (www.techdays.se)
  • Microsoft Partner Event: New in SC2012 SP1
  • User group meetings (PSUG.DK , SCUG.DK/BE/NO, AZMUG + more)
  • Microsoft Certified Trainer.
  • Microsoft Scripting Guys Forum Moderator

Main working areas:

  • Automation (Azure Automation, SMA, SCO)
  • Windows Azure Pack / Azure Stack
  • System CenterVisual Studio Team Services / Team Foundation Server
  • Development:C#.Net, VB.NET, VBScript, PowerShell, Service Manager, OpsMgr, ConfigMgr
  • Orchestrator
  • Windows Azure Pack / Azure Stack

Training:

  • Azure Automation
  • Service Management Automation
  • System Center Orchestrator
  • PowerShell, VBScript, C#.Net, VB.Net
  • Windows Azure Pack / Azure Stack Development Workshops

3 Comments

  1. Phuket sightseeing September 19, 2014 at 6:01 - Reply

    Phuket sightseeing

    Coretech Blog » Blog Archive » System Center Orchestrator 2012 Beta: Creating an overview of RunBooks using Orchestrator Web Service and PowerPivot For Excel

  2. maxsize male enhancement cream case of 24

    Coretech Blog » Blog Archive » System Center Orchestrator 2012 Beta: Creating an overview of RunBooks using Orchestrator Web Service and PowerPivot For Excel

  3. […] replace the $rbaid with your runbook ID.  An easy way to do this is using Power Pivot in excel.  Here is a good article on how to do that.  Take note of the warning that all of the GUIDs must be […]

Leave A Comment