Hot off the press: Service Manager 2012 Unleashed book

The System Center 2012 Service Manager Unleashed book is finally done! I received some copies of it on Friday. It is set to publish on Monday October 6th 2014. Here is the link for it and a picture below.

http://www.amazon.com/System-Center-Service-Manager-Unleashed/dp/067233707X

SCSM 2012 Unleashed

There was a great team of people behind this book consisting of well-known folks in the Service Manager community from MVP’s, MCT’s, expert consultants, and even Microsoft staff. Authors included me, MVP Kerrie Meyler, MVP Kurt Van Hoecke, and MCT Sam Erskine. Contributors include MVP Jakob Svendsen, Microsoft employee Kathleen Wilson, MCT Kenneth Surksum, Oskar Landman, MVP Patrik Sundqvist, and Peter Quagliariello. Even the foreword was done by former Microsoft program manager and now MVP Christian Booth and Service Manager program manager Srikanth Ranganathan.

This book is packed with tons of “why” and “how to” content for Service Manager. If you have Service Manager deployed or you are about to embark on a Service Manager project add this book to your library. Here is an overview of the content in the book:

This comprehensive resource will help you automate and optimize all facets of service management with System Center 2012 Service Manager.

Expert consultants offer deep “in the trenches” insights for improving problem resolution, change control, release management, asset lifecycle management, chargeback, and more. You’ll learn how to implement high-value best practices from ITIL and the Microsoft Operations Framework.

The authors begin with an expert overview of Service Manager, its evolution, and its new capabilities. Next, they walk through overall planning, design, implementation, and upgrades. Then, to help you focus your efforts, they present stepwise coverage of all topics in each feature area, linking technical information about Service Manager with essential knowledge about the technologies it depends on.

Whatever your role in deploying or running Service Manager, this guide will help you deliver more responsive support at lower cost and drive more value from all your IT investments.

• Leverage MOF and ITIL processes built into System Center 2012 Service Manager
• Plan and design your Service Manager deployment
• Install Service Manager or upgrade from earlier versions
• Efficiently administer work and configuration items
• Use connectors to integrate with Active Directory, Exchange, and System Center components
• Create service maps
• Enable end user access through Service Manager’s self-service portal
• Implement incident, problem, change, and release management
• Utilize workflows to automate key support processes
• Create service level agreements with calendars, metrics, and objectives
• Provide quick access to a standardized catalog of services
• Use notification to ensure that Service Manager items are promptly addressed
• Secure Service Manager and its data warehouse/reporting platform
• Perform maintenance, backup, and recovery
• Manage Service Manager performance
• Customize Service Manager

http://www.amazon.com/System-Center-Service-Manager-Unleashed/dp/067233707X

Read more

Point SCSM DW & WAP Request Management to new SQL server

I recently worked with a client that hosted the Service Manager database on a SQL cluster. They manually failed over the SCSM database to the other node in the SQL cluster. Request Management in Azure Pack and the SCSM data warehouse were still trying to communicate with Service Manager using the old node in the SQL cluster. We needed a way to manually flip both Azure Pack and The DW over to the new node in the SQL cluster. Below is how I did this. I am posting about this in case it saves anyone else time and for me if I need it for future reference.

GridPro Request Management in Windows Azure Pack Failover:

Navigate to: C:\inetpub\MgmtSvc-RequestManagementAPI

Open the “solidConnectionSettings.config” file in a text editor such as notepad.

Modify the highlighted value in the connection string to the name of the second node in the SQL cluster:

<connectionStrings>

<add name=”ServiceManagerCMDB” connectionString=”Server=SQLSERVER1,1433;Database=ServiceManager;Integrated Security=True”/>

</connectionStrings>

 

After this is modified an IIS reset is needed. After that the Request Management in Windows Azure Pack should now attempt to connect to Service Manager on the correct SQL node.

Service Manager Data Warehouse failover:

In regards to the data warehouse we needed to re-point this to the second node in the SQL cluster. To do this I:

Opened the DWStagingAndConfig database.

Open the MT_Microsoft$SystemCenter$ResourceAccessLayer$SqlResourceStore table.

And

Run Select * from MT_Microsoft$SystemCenter$ResourceAccessLayer$SqlResourceStore

Or

Right click on the table and Select Top 1000 rows. (Don’t worry there are only 10 rows in this table.)

clip_image001.png

 

Note the 5th row column DataService_98B2DDF9_D9FD_9297_85D3_FCF36F1D016B has Service Manager listed. Further along in row 5 under column Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA it has the SQL server for Service Manager that it is pointed to listed. This is what needs to be changed. You can see this in the following screenshot:

clip_image002.png

To change this run the following:

UPDATE MT_Microsoft$SystemCenter$ResourceAccessLayer$SqlResourceStore

SET Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA = ‘SQLSERVER2’

WHERE DataService_98B2DDF9_D9FD_9297_85D3_FCF36F1D016B = ‘ServiceManager’

NOTE: Be sure to replace SQLSERVER2 with the name of your new SQL node.

Now if you Run Select * from MT_Microsoft$SystemCenter$ResourceAccessLayer$SqlResourceStore

You will see row 5 in the Server_48B308F9_CF0E_0F74_83E1_0AEB1B58E2FA column will reflect the change.

clip_image003.png

Read more

Error installing Service Manager with SQL Alwayson

Recently I was deploying a new Service Manager and I was placing the Service Manager database on a SQL 2012 AlwaysON Availability Group. I was specifying the Database server as Availability Group listener DNS name. This is supported with Service Manager. Here are two links the first shows it is supported and the second has install steps for deploying SCSM to a SQL 2012 AlwaysON Availability Group.

Link 1:

http://technet.microsoft.com/en-us/library/hh495585.aspx

Link 2:

http://blogs.technet.com/b/servicemanager/archive/2013/02/25/how-to-install-system-center-2012-service-manager-sp1-with-a-sql-2012-alwayson-availability-groups.aspx

The Service Manager wizard did not see the Availability Group. I got an error that SQL services were not running. The following screenshot shows the error.

SCSM-AG-Error

I checked the SQL services and they were fine and my SQL Availability Group was not a named instance.

The strange thing is if I specified the Database server as the IP of the Availability Group or cluster name the wizard would not error out. I could not get Service Manager to install using the SQL Availability Group listener DNS name. Here is what I did to work around this issue:

  1. Installed the Service Manager database to one of the SQL nodes.
  2. Installed the rest of my management servers.
  3. Added the Service Manager database to the Availability Group.
  4. Re-pointed Service Manager registry key DatabaseServerName from the SQL node to the SQL Availability Group listener DNS name. To do this I followed the steps on this TechNet article:

http://blogs.technet.com/b/servicemanager/archive/2012/04/22/moving-the-service-manager-and-dw-databases.aspx#pi144248=2

After completing those steps the Service Manager database was running successfully on the SQL Availability Group. I was able to simulate a failover and everything worked as it should.

Read more

Featured on IT PRO Experts

Lee Berg a Systems Management Specialist, active member in the System Center community and now coworker of mine at Concurrency.com has a great YouTube channel https://www.youtube.com//LeeAlanBerg with Microsoft technology videos for the IT Pro community. It features Weekly Service Manager and Private Cloud round up’s, Demos, Reviews, and Interviews. Lee has been doing these IT … Read more

Service Manager SP1 Update Rollup 4 Error

I recently ran across some problems when trying to update System Center Service Manager SP1 with Update Rollup 4 (UR4) (http://www.microsoft.com/en-us/download/details.aspx?id=40836). Here is the error: “Microsoft System Center 2012 Service Pack 1 Service M has stopped working“.   There is a Temp folder on management servers with SCSM setup logs like in the screenshot. The … Read more

Remove Orphaned Connectors in Service Manager

PROBLEM: Recently I came across a Service Manager environment that had some old SCOM 2007 connectors that were no longer being used. These SCOM 2007 connectors would not remove from the SM console and would throw the following error when trying to remove. This is an easy fix. Use the SMLets to remove this connectors … Read more

Free SCSM, SCOM, DPM Tools for the Community

Wow what an exciting week in the System Center space! Lately there has been several free tools released for various System Center products in the community. I wanted to mention them here in one blog. Service Manager: Advanced Send Mail This one is very cool and something that has been needed for some time. Big … Read more

Launch a Runbook from a Service Manager Console Task

I recently ran across the question of “How Can I Launch a Runbook from a Console Task?” in this forum thread:

http://social.technet.microsoft.com/Forums/systemcenter/en-US/5cd957fa-5114-41fe-a727-3294df74a7b0/how-can-i-launch-a-runbook-from-a-console-task?forum=customization .

I started thinking about how this could be useful in certain scenarios and how this would work. I decided to figure this out and blog about it so here it is. First you will need a tool that can connect to Orchestrators web service and start runbooks. There is such a tool called Orchestrator Remote Tools 2.51.

With this tool you also have the ability to discover information about runbooks on an Orchestrator server, pass parameters to the tool and see the status on if the runbook started successfully or failed. This tool has a GUI and command line interface.

This tool only discovers runbooks that have an “Initialize Data” activity. This tool launches runbooks looking to a generated .XML template with information about the runbook or it can launch runbooks directly without the XML template file (CLI mode only). for The tool consists of three components:

  1. UI Generator (ORTUIGenerator.exe): This is what discovers all your runbooks and allows you to browse them. You also use this component to generate the XML template files.
  2. Remote Runbook Launcher (ORTRunbookLauncher.exe): Is the graphical way to launch runbooks.
  3. Remote Runbook Launcher CLI (ORTRunbookLauncherCLI.exe): Is the command line way to launch runbooks.

You can learn more about the tool here:

http://blogs.technet.com/b/yasc/archive/2011/11/17/orchestrator-remote-tools-2-0-fka-the-opalis-ui-generator.aspx

It can be downloaded here:

http://orchestrator.codeplex.com/releases/view/76983

Let’s work with the tool to prepare for using it with Service Manager. Create a share on your Service Manager management server. This can be something like \\SMSERVER\ORT\.

Copy the Orchestrator Remote Tools into it. You should have the following:

clip_image001[4]

Now click on ORTUIGenerator.exe . You will see this popup message:

clip_image002[4]

Click OK. This is telling you it is the first time you have run the tool and you need to put in your Orchestrator settings.

You will see the following window and will need to complete all the fields.

NOTE: Once you put in the data base server it will automatically pull in the Orchestrator database. If your SCORCH DB is not named Orchestrator you will be able to click the drop down and select it.

Click Save when you are done. Clicking Save will create a Config.xml file in your ORT directory.

clip_image003[4]

Now the UI Generator window will pop up. This is the window you use to generate the .XML template file.

On the left hand side you are able to browse through the discovered runbooks. Keep in mind it only finds runbooks that have an “Initialize Data” activity. To configure the template for a runbook browse to it on the right hand side, select it and click the “Get details for the selected runbook” button. It will then expose the settings of the “Initialize Data” activity for the runbook on the right hand side. Here is where you can configure values for the parameters and give the runbook a description for those that will be running it. Note you are not required to configure values for the parameters. When you are ready to generate the .XML template click on the “Create Runbook Launcher configuration file” button.

clip_image004[4]

You should now have a policy_template.xml in your ORT directory. By default when you run ORTRunbookLauncher.exe or ORTRunbookLauncherCLI.exe the policy_template.xml will be used allowing you to only have settings for one runbook at a time. You can elect to use another file by using the /ORTXML switch. What this does is allows you to store multiple XML templates in the same directory by different names and launch the specific one you want.

The /ORTXML switch only works using ORTRunbookLauncherCLI.exe as it is passed as a parameter. Another way around this if you are stuck on using the GUI component is to create multiple folders and put the exe’s, config file in each folder as it will have its own policy_template.xml file. That however could become a nightmare to manage and requires more space. I recommend using the /ORTXML switch.

Let’s look at the GUI component. In the ORT folder launch ORTRunbookLauncher.exe. The Runbook Launcher window will pop up. It should look similar to the following screenshot.

Input the parameters and click “Start Runbook” button.

clip_image005[4]

It is that easy to remotely launch a runbook using this tool. Using the ORTRunbookLauncherCLI.exe is basically doing the same thing except it is running from a command line allowing you to pass in the values for the parameters right in the command. The syntax for starting a runbook using the ORTRunbookLauncherCLI.exe would look like this:

ORTRunbookLauncherCLI.exe /LastName=Sinatra /Location=”Building 45″ /Department=Sales /Title=”VP of Sales” /FirstName=Frank /SamAccount=Franks /”Reporting To”=”John Adams”

 

NOTE: If the parameters’ names or values have spaces, you need to enclose them using double quotes.

clip_image006[4]

Ok, so now let’s combine the tool with Service Manager and its CMDB. Think about all the possibilities. There are a lot of useful scenarios in which these two could be utilized. A couple of possibilities I can think of off the top of my head are: Pass a user from Service Managers CMDB to this tool as a parameter and have a runbook disable a user in AD, pick up a computer from the CMDB pass it as a parameter to a runbook and move the computer from one OU to another in AD.

I don’t see this tool as a replacement for using Runbooks with Service Requests in Service Manager. I see this as more of a way to give the administrative team a quick and easy way to launch runbooks without ever leaving the Service Manager console.

Let’s look at how we can bring the Orchestrator Remote Tools and Service Manager together, create a console task and accomplish a task.

For this blog post we are going to use a very simple disable user runbook. To do this we need to create a console task using the ORT tool. Use the following steps to do this:

Read more

Service Manager: Request Offering Multiselect User Prompt

Background:

Recently at a client of mine I was building a new hire Request Offering for them. I ran into a roadblock because they needed a software list to be able to select software from that list that needed to be installed for certain users only. Yes they had SCCM and OSD with standard builds. The software on this list however was on a case by case basses and not a part of the main build. This information needed to be communicated through the Request Offering form so that the team member building the new computer would know what software outside of the main build needed to be installed.

Problem:

The problem is that when you create a user prompt with prompt type list on a Request Offering you can add the list of software but this cannot be a multi-select. You can only select one item in a prompt type list.

An alternative is to use a prompt type of query results. This prompt type allows multi-select. The query results prompt type queries Service Managers CMDB and presents a list of configuration items (CI’s) to a user on the actual Request Offering form like in the following screenshot.

clip_image001.png

I had the SCCM connector setup and was already pulling software into the CMDB. The problem here is that there are 2,000+ software CI’s and there is no way anyone wants to sift through that many CI’s when filling out a form.

There are only 10 software products that were needed on the build list for new hires. What I needed to do was get these 10 software products into the CMDB as CI’s or flag existing ones and expose only these 10 on the Request Offering for a user to select from.

Solution:

Here is what I did to get around this problem. Essentially I needed to accomplish two things and they were:

    1. Bring or flag the 10 software products in the CMDB.
    2. Create a Query Results prompt type that is filtered to the 10 software CI’s to be exposed in the Request Offering.

Read more

Custom Service Request Area

There is an issue that has been around for some time were you cannot delete items from the Service Request Area list in Service Manager 2012. You can do this to the Incident Classification and Change Area but not the Service Request Area. See references to this issue here: http://social.technet.microsoft.com/Forums/systemcenter/en-US/952d60eb-392f-4fa4-928f-c61da91616cc/how-to-delete-scsm-2012-by-default-service-request-area-and-service-request-priority?forum=customization http://social.technet.microsoft.com/Forums/systemcenter/en-US/b1d2255a-86bd-421a-9d81-2dfbf32854c1/how-do-i-edit-a-service-request-area-on-lists http://social.technet.microsoft.com/Forums/systemcenter/en-US/48086671-a7b8-4f1d-aafa-96e33d0fad26/why-can-you-modify-incident-classification-and-change-area-but-cant-modify-service-request-area http://www.systemcentercentral.com/forums-archive/topic/delete-service-request-area-list-entries/ Incident Management, … Read more