scorch – fun recipes for runbooks mms minnesota 2014 steve jesok & matthew teegarden...

MMS Minnesota 2014

SCORCH – Fun Recipes for RunBooks

Steve Jesok & Matthew Teegarden@SteveJesokhttp://mnscug.org/blogs/steve-jesok

#MMSSCOrch

MMS Minnesota 2014

Our Agenda

• Orchestrator Overview• Things to consider when building RunBooks• Let make some things happen!• Create an AD User• Monitor SCCM Application Requests• Monitoring Scorch with Scorch• Reporting, reporting, reporting…• Import Inventory Data to SCCM• PowerShell and SCCM• Trigger SSRS Reports

MMS Minnesota 2014

SCOrch Overview

Components• Runbook Designer• Web Console• Deployment Manager• Web Service• Database

MMS Minnesota 2014

Things to consider

• Keep runbooks modular, they are building blocks• Initiation, Control, and Components

• Keep things tidy, aka avoid 50 steps in a RunBook•Watch RunBook performance•Orchestrator is meant to automate, not replace other tools.• Control SCCM, controls SSRS, use the existing

building blocks.

MMS Minnesota 2014

Create AD User

• Create an AD User and Send Data To SCSM

•Demo

MMS Minnesota 2014

Monitor SCCM Application Requests

• Create Notifications for SCCM Application Requests• Query the database to pickup requests• Drop the items in Sharepoint• Action the approved requests

MMS Minnesota 2014

Monitoring SCOrch with SCOrch

• Rather than watch them all, just watch one.• SharePoint List• Monitor Runbook• Component Runbook• Email Alerts

MMS Minnesota 2014

Reporting doesn’t have to be have hard…

• Finding issues in the Designer console• Always reactive• Notified something is wrong, after it has happened at

least once.• Use the logging pane in Runbook Designer• Log History• Audit History• Events• All of this data is in the database!• Get it here

MMS Minnesota 2014

Import Inventory Data into SCCM

• Company Inventory Data• Import MOF• Run SQL queries to discover• MOF Inbox drop• Data in one place• Why, dynamic collections based on users assigned

computer equipment

MMS Minnesota 2014

SCCM and PowerShell

•Using the SCCM Cmdlets with SCCM• Leverage PSSession• Block Boot Media• Monitor limiting collections

MMS Minnesota 2014

Execute an SSRS Report

• Leverage a little SQL• Create a Report• Create a Report Subscription• Grant access to the service acct• Edit extension settings and fire• Check the status of the report

MMS Minnesota 2014

Automated the small parts then go big!

• Start with the small parts then go big• Automate collection management for software

deployments• Automate OSD and Refreshes• Automate management of dead objects in AD• Use automated SSRS integration to dynamically send

reports

MMS Minnesota 2014

Where can I get more information?

Resources

Orchestrator Team Blog - http://blogs.technet.com/b/orchestrator/

Andorfer’s Blog - http://opalis.wordpress.com/

Anders’ Blog - http://contoso.se/blog/

Codeplex SCOrch - http://scorch.codeplex.com/

Orchestrator eBook - http://blogs.msdn.com/b/microsoft_press/archive/2013/09/18/free-ebook-system-center-designing-orchestrator-runbooks.aspx

SMA - http://gallery.technet.microsoft.com/Service-Management-fcd75828/file/107343/4/Service%20Management%20Automation%20whitepaper-1.0.3.pdf

Download and use Feedly!

Session Title

EvaluationsPlease provide session feedback by clicking the Eval button in the scheduler app. One lucky winner will get a free ticket to the next MMS!

Visit all of our sponsors in the expo area and online!

Platinum Sponsors:

Gold Sponsors:

MMS Minnesota 2014