先日の2023年11月13日（日本時間）、System Center 2022 Update Rollup 2 がリリースされました。
Update Rollup 2 for System Center 2022 によると下記コンポーネント向けに提供されていますね。
聞いたところによると、リリースされたらしい。がサポート情報が見つけられないでいます。。。
検索したところ、Microsoft Update カタログには、
見落としていたのですが、SQL Server 2019をサポートしている System Center 2019 は、下記のとおりです。
ServiceNow ActivitiesServiceNowのレコードに含まれて添付ファイルをダウンロードできるようなので、いろいろ使い道がありそうな気がしますね。
Create Record – activity dynamically creates new ServiceNow records using standard or customized ServiceNow forms.
Get Record – activity returns records meeting specific filter conditions
Update Record – activity updates specific records
Delete Record – activity deletes specific records
Monitor Record - monitor for new or updated ServiceNow records
Upload Attachment – activity uploads attachment to ServiceNow record
Download Attachment - activity downloads attachment from ServiceNow record
Import Set - activity inserts a record into a ServiceNow import set table
Run Query - retrieves records from a ServiceNow table using a ServiceNow encoded query string
Run Scripted Web Service - runs a ServiceNow scripted web service (Only in SOAP IP)
Activities subscribe and publish data to the Orchestrator databus.
3 What Systems Can Orchestration Automate?アクティビティのサマリを上記ページより転記します。
VMware (through vCenter)
Amazon EC2 instances
Any system presenting web services
Windows Active Directory
Microsoft Exchange mail servers
Puppet Labs Puppet (with configuration automation)
Opscode Chef (with configuration automation)
Any system accessible from the command line
5 Orchestration Activities in Workflow
The Orchestration plugin adds these types of activities for use with workflows:
Basic Orchestration activities
SSH activities
Active Directory activities
VMware activities
Amazon EC2 activities
PowerShell activities
Puppet
Chef activities
Exchange activities
$Session=New-PSSession -ComputerName "scsmhost"
Invoke-Command -Session $session -ScriptBlock {
Import-Module 'C:\Program Files\Microsoft System Center\Service Manager\PowerShell\System.Center.Service.Manager.psd1'
Import-Module SMLets
$SMServer="scsmhost"
# SCSMのアクティビティIDを指定し、SMLetsのGet-SCSMObjectでGUIDを取得できるようにしています。# http://www.lazywinadmin.com/2014/09/powershellscsm-finding-guid-of-object.html
# http://smlets.codeplex.com/documentation Shutdown to Dec-2017
$ServiceRequest = Get-SCSMObject -Class (Get-SCSMClass -Name System.WorkItem.ServiceRequest) -filter "ID -eq SCSMのアクティビティIDを指定"
#
$SR=Get-SCClassInstance -ComputerName $SMServer –Id $ServiceRequest.get_id()
#英語環境で作ったはずですが、なぜかDisplayNameで日本語名を指定しないとうまくいきませんでした。
$targetclass=Get-SCSMRelationship -ComputerName $SMServer -DisplayName "添付ファイルがある" | where {$_.Source -eq (get-scsmclass -ComputerName $SMServer -Name System.WorkItem)}
# $targetclass=Get-SCSMRelationship -ComputerName $SMServer -DisplayName "Has File Attachment" | where {$_.Source -eq (get-scsmclass -ComputerName $SMServer -Name System.WorkItem)}
$files=$SR.GetRelatedObjectsWhereSource($targetclass)
$ArchiveRootPath="C:\Temp\OrchestratorRemote\"
#For each file, archive to entity folder
$filelist=@()
if($files -ne $Null)
{
#Create archive folder
$nArchivePath=$ArchiveRootPath + "" + $SR.Id
New-Item -Path ($nArchivePath) -ItemType "directory" -Force|Out-Null
$files|%{
Try
{
$filelist+="$nArchivePath$_"
$fileId=$_.EnterpriseManagementObject.Id
$fileobject=get-scsmclassinstance -ComputerName $SMServer -Id $fileId
$fs = [IO.File]::OpenWrite(($nArchivePath + "\" + $_.EnterpriseManagementObject.DisplayName))
$memoryStream = New-Object IO.MemoryStream
$buffer = New-Object byte[] 8192
[int]$bytesRead|Out-Null
while (($bytesRead = $fileobject.Content.Read($buffer, 0, $buffer.Length)) -gt 0)
{
$memoryStream.Write($buffer, 0, $bytesRead)
}
$memoryStream.WriteTo($fs)
}
Finally
{
$fs.Close()
$memoryStream.Close()
}
}
}
$file1=$filelist[0]
$file2=$filelist[1]
$file3=$filelist[2]
}
Remove-PSSession $Session
System Center Service Provider Foundation is an extensible OData web service backed by an SQL database. The database will be added to the SQL AlwaysOn Availability Group.
