Set-SCSMTemplateWithActivities powershell script

Hey, I’ve come up with a solution that quickly checks a whole management pack for missing prefixes and fixes them. Here’s the source:

Repair-ManagementPackExport managementpackName.xml

.INPUTS
System.String

.NOTES
If this file does not have strings requiring repair, then it will not be modified.

.VERSION
1.1

#>
function Repair-ManagementPackExport
{
param ( [parameter(mandatory=$true)] [System.String] $xmlFileFullPath )

# Select all nodes which contain a child path attribute that has a description, but does not contain a child path having an ID
# note, special use of @ char, the last line with the “@ character must have no white space before it or the multiline string won’t be recognized
[string] $xPathExpression = @”
//*[
Property[contains(@Path, “$Context/Property[Type=’CustomSystem_WorkItem_Library!System.WorkItem’]/Description$”)] and
not (Property[contains(@Path, “$Context/Property[Type=’CustomSystem_WorkItem_Library!System.WorkItem’]/Id$”)])
]
“@

$ErrorActionPreference = “Stop”

try
{

if (-not (Test-Path $XmlFileFullPath))
{
$msg = “The file $XmlFileFullPath does not exist.”
throw [System.IO.FileNotFoundException] $msg
}

$xmlFileFullPath = Resolve-Path -Path $xmlFileFullPath

[Xml.XmlDocument] $xdoc = Get-Content $XmlFileFullPath
[Xml.XmlNodeList] $nodes = $xdoc.SelectNodes($xPathExpression)

if ($nodes -eq $null)
{
Write-Host “No errors detected”
return
}

[int] $nodeCount = $nodes.Count
Write-Host “Starting Operation – Adding $nodeCount missing ID tags in XML”

[Xml.XmlElement] $newNode = $null

for ([int]$i=0; $i -lt $nodeCount; ++$i)
{

$newNode = $xdoc.CreateElement(‘Property’)
$newNode.SetAttribute(‘Path’, ‘$Context/Property[Type=”CustomSystem_WorkItem_Library!System.WorkItem”]/Id$’)

$newNode.InnerText = ”
[Xml.XmlElement] $elementToInsertAfter = $null

# check first to see if the activity type is defined at the higher level object. If it is, use this path since the children propty objects will only
# contain generic system activity paths
if ($nodes[$i].Path -ne $null)
{
$newNode.InnerText = ReturnIDType $nodes[$i].Path
}

foreach ($propElement in $nodes[$i].Property)
{
# only process if we haven’t found the element to insert after
if ($elementToInsertAfter -eq $null)
{
# find the correct location to insert the new node (insert right below the ID node
# this is being done because there are times when the objects that require this node insertion have nested objects. If the ID tag for the higher level object gets
# inserted below the child object, it’ll be considered invalid, so just safer to place around title

if ($propElement.Path.Contains(“`$Context/Property[Type=’CustomSystem_WorkItem_Library!System.WorkItem’]/Description$”))
{
$elementToInsertAfter = $propElement
}
}

# only process if we haven’t yet found the activity type
if ($newNode.InnerText -eq ”)
{
$newNode.InnerText = ReturnIDType $propElement.Path
}

# we found all the info we need, break out early
if ( ($newNode.InnerText -ne ”) -and ($elementToInsertAfter -ne $null) )
{
break
}
}

# the innerText is empty if we have a template without activities, in this case we do not need the ID
if ($newNode.InnerText -ne ”)
{

if ($elementToInsertAfter -eq $null)
{
throw “We have an issue with the XML formation. Expected Description tag is missing. Please review the Management pack file being submitted.”
}

$tmp = $nodes[$i].InsertAfter($newNode, $elementToInsertAfter);
}
}

# we don’t have a document encoding element, add one so that we don’t lose character encoding
if ($xdoc.DocumentElement.OwnerDocument.xml -eq $null)
{
[Xml.XmlElement] $root = $xdoc.DocumentElement
[Xml.XmlDeclaration] $xmldecl = $xdoc.CreateXmlDeclaration(“1.0″,”UTF-16″,””)
$tmp = $xdoc.InsertBefore($xmldecl, $root)
}

$xdoc.Save($XmlFileFullPath)
Write-Host “Completed Operation – Added $nodeCount missing ID tags in XML.”
}
catch
{
# Throwing an exception in this manner will actually bubble up to the Orchestrator runbook activity and give an error condition.
Throw
}
}
Export-ModuleMember -Function Repair-ManagementPackExport

#region Private functions

function ReturnIDType
{
param ( [parameter(mandatory=$true)] [System.String] $pathText )

# only load this settings object once (create a script level variable, acting like a static for this session)
if ($script:activitySettingsObj -eq $null)
{
$script:activitySettingsObj = Get-SCSMObject -Class (Get-SCSMClass -Id “5e04a50d-01d1-6fce-7946-15580aa8681d”)
}

[string] $retVal = ”

if ($pathText.Contains(“Microsoft.SystemCenter.Orchestrator.RunbookAutomationActivity”))
{
$retVal = $script:activitySettingsObj.MicrosoftSystemCenterOrchestratorRunbookAutomationActivityBaseIdPrefix
}
elseif ($pathText.Contains(“System.WorkItem.Activity.ManualActivity”))
{
$retVal = $script:activitySettingsObj.SystemWorkItemActivityManualActivityIdPrefix
}
elseif ($pathText.Contains(“System.WorkItem.Activity.ReviewActivity”))
{
$retVal = $script:activitySettingsObj.SystemWorkItemActivityReviewActivityIdPrefix
}
elseif ($pathText.Contains(“System.WorkItem.Activity.ParallelActivity”))
{
$retVal = $script:activitySettingsObj.SystemWorkItemActivityParallelActivityIdPrefix
}
elseif ($pathText.Contains(“System.WorkItem.Activity.SequentialActivity”))
{
$retVal = $script:activitySettingsObj.SystemWorkItemActivitySequentialActivityIdPrefix
}
elseif ($pathText.Contains(“System.WorkItem.Activity.DependentActivity”))
{
$retVal = $script:activitySettingsObj.SystemWorkItemActivityDependentActivityIdPrefix
}

if ($retval -ne ”) { $retVal += “{0}” }
return $retVal
}

#endregion

Thank you very much for the author to solve my problem.I met the question is, can’t find the first activity in the template and its status is set to start.On the basis of the author code changes：
Note: in the template avtivities number order must, from top to bottom is growing up.
1:Changes in the Apply-SCSMTemplate function.

#Update Activities in template
[int]$count = 0
foreach ($TemplateObject in $Template.ObjectCollection)
{
Update-SCSMPropertyCollection -Object $TemplateObject
$count++;
}

2:Changes in the Update-SCSMPropertyCollection function.

#Regex – Find class from template object property between ! and ‘]
$pattern = ‘(?<=!)[^!]+?(?=''])'
if (($Object.Path) -match $pattern -and ($Matches[0].StartsWith("System.WorkItem.Activity") -or $Matches[0].StartsWith("Microsoft.SystemCenter.Orchestrator")))
{
#Handle the first Activity
if ($count -eq 0)
{
#Create template property object
$propClass = [Microsoft.EnterpriseManagement.Configuration.ManagementPackObjectTemplateProperty]
$propObject = New-Object $propClass

#Add new item to property object
$propObject.Path = "`$Context/Property[Type='$aliasActivity!System.WorkItem.Activity']/Status$"
$propObject.MixedValue = "11fc3cef-15e5-bca4-dee0-9c1155ec8d83"

#Add property to template
$Object.PropertyCollection.Add($propObject)
}

#Set prefix from activity class
$prefix = Get-SCSMObjectPrefix -ClassName $Matches[0]
…
…
}

This script deservingly merits full praise, well done in figuring out the required objects and how to apply them to automate a request offering. For someone that has just stepped aboard the SCSM platform a fortnight ago, I did not know where to start. This script has saved my skin. Thank you,

I call this script at the end of a powershell script that creates a service request.
The first time it works.

But if a service request aleady exists where the script Set-SCSMTemplatewithActivities.ps1 has been applied onto,
I get the error message:

Set-SCSMObjectTemplate : Ungültige Formatspezifikation: “s} already has lifetime dependency defined by relationship id = (%s).”.
In Set-SCSMTemplatewithActivities.ps1:100 Zeichen:5
+ Set-SCSMObjectTemplate -Projection $Projection -Template $Templat …
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidOperation: (Template.03f311…32d32af02cc80c2:ManagementPackObjectTemplate) [Set-SCSMObjectTemplate], UnknownDatabaseException
+ FullyQualifiedErrorId : ApplyTemplate,SMLets.SetSCSMObjectTemplateCommand

Anyone an idea what I am doing wrong?