After upgrading my SCSM management server to SP1, I found that my management server would not start. The only error I could find in the logs that was related was this error that wasn’t very helpful.

The Management Group <MGNAME> failed to start.  The error message is 0x80131701(0x80131701).  A previous message with more detail may have been logged.

Continue reading

I’m preparing to upgrade my SCSM environment to SP1 one of the Prerequisites is to stop the SCSM DW jobs. I decided that since this is a requirement to do every six months or so and I don’t want to relearn how to use them cmdlets every time. I always forget to use the –computer parameter and the powershell cmdlet fails. This also allows me to just export the two runbooks I created out of my lab environment and into production. The scripts below will figure out what your Extract jobs are called you just need to update the server name.

Create a new runbook for stopping the DW jobs and paste the following code into a Run .net Script

$SMModule
=
“C:PowershellModulesService ManagerPowershellSystem.Center.Service.Manager.psd1”

$SMDWModule
=
“C:PowershellModulesService ManagerMicrosoft.EnterpriseManagement.Warehouse.Cmdlets.psd1”

Import-Module
-force
$SMModule

Import-Module
-force
$SMDWModule

$SCDWJobs
= @(“Transform.Common”,“Load.common”)

$SCDWMGJobs
=
Get-SCDWJob
-computer
SCSMDW01
|
where {$_.Name -match
‘Extract*’}

foreach ($SCDWMGJob
in
$SCDWMGJobs){

Disable-Scdwjobschedule
-JobName
$SCDWMGJob.Name -ComputerName
SCSMDW01

}

foreach ($SCDWJob
in
$SCDWJobs){

Disable-Scdwjobschedule
-JobName
$SCDWJob
-ComputerName
SCSMDW01

}

The Start runbook is the same concept just need to use the Enable-SCDWJobSchedule

$SMModule
=
“C:PowershellModulesService ManagerPowershellSystem.Center.Service.Manager.psd1”

$SMDWModule
=
“C:PowershellModulesService ManagerMicrosoft.EnterpriseManagement.Warehouse.Cmdlets.psd1”

Import-Module
-force
$SMModule

Import-Module
-force
$SMDWModule

$SCDWJobs
= @(“Transform.Common”,“Load.common”)

$SCDWMGJobs
=
Get-SCDWJob
-computer
SCSMDW01
|
where {$_.Name -match
‘Extract*’}

foreach ($SCDWMGJob
in
$SCDWMGJobs){

Enable-Scdwjobschedule
-JobName
$SCDWMGJob.Name -ComputerName
SCSMDW01

}

foreach ($SCDWJob
in
$SCDWJobs){

Enable-Scdwjobschedule
-JobName
$SCDWJob
-ComputerName
SCSMDW01

}

I just completed upgrading my lab install of Orchestrator and wanted to blog a few minor notes. This blog post just covers the high level steps.

If you have all of the System Center 2012 products installed this is the first system center product to upgrade to SP1 if you are following the Sequencing guide provided by Microsoft.

Most important steps of the upgrade are to make sure you have a backup of the database, if you are running Orchestator in a VM I would recommend a snapshot also if this is a production environment.
Continue reading

In this Blog post I’m going to cover how I created an AD group Connector to update the CMDB with some extended properties for AD groups.

I wanted to be able to publish the description field for AD Groups in the SCSM portal so it is easy for the end users to know what the purpose of the group is, so they can request to be added to the group then the owner of the group can get the approval notification.

to do this I needed to extend the AD Group class with the SCSM Authoring tool. Continue reading