Deploy SCO IP using Powershell

comObject.types.ps1xml

<Types>
    <Type>
        <Name>System.__ComObject</Name>
        <Members>
            <ScriptMethod>
                <Name>GetProperty</Name>
                <Script>
                    $type = $this.gettype();
                    $type.invokeMember($args[0],[System.Reflection.BindingFlags]::GetProperty,$null,$this,$null)
                </Script>
            </ScriptMethod>
            <ScriptMethod>
                <Name>SetProperty</Name>
                <Script>
                    $type = $this.gettype();
                    $type.invokeMember($args[0],[System.Reflection.BindingFlags]::GetProperty,$null,$this,@($args[1]))
                </Script>
            </ScriptMethod>
            <ScriptMethod>
                <Name>InvokeParamProperty</Name>
                <Script>
                    $type = $this.gettype();
                    $index = $args.count -1 ;
                    $methodargs=$args[1..$index]
                    $type.invokeMember($args[0],[System.Reflection.BindingFlags]::GetProperty,$null,$this,$methodargs)
                </Script>
            </ScriptMethod>
            <ScriptMethod>
                <Name>InvokeMethod</Name>
                <Script>
                    $type = $this.gettype();
                    $index = $args.count -1 ;
                    $methodargs=$args[1..$index]
                    $type.invokeMember($args[0],[System.Reflection.BindingFlags]::InvokeMethod,$null,$this,$methodargs)
                </Script>
            </ScriptMethod>
        </Members>
    </Type>
</Types>

Install-IP.ps1

function LoadTypeData()
{
# Load some TypeData
$SavedEA = $Global:ErrorActionPreference
$Global:ErrorActionPreference = "SilentlyContinue"
Update-TypeData -AppendPath "C:\DeployIP\comObject.types.ps1xml"
$Global:ErrorActionPreference = $SavedEA
}

function global:Get-MsiProperty
{
    PARAM (
    [Parameter(Mandatory=$true,ValueFromPipelineByPropertyName=$true,ValueFromPipeline=$true)]
    [String]$Filename,

    [Parameter(Mandatory=$true,ValueFromPipelineByPropertyName=$true,ValueFromPipeline=$true)]
    [String]$Propertyname
    )

    # A quick check to see if the file exist
    if(!(Test-Path $Filename))
    {
        throw "Could not find " + $Filename
    }     

    # Create an empty hashtable to store properties in
    $msiProp = @{}
    # Creating WI object and load MSI database
    $wiObject = New-Object -com WindowsInstaller.Installer
    #$wiObject | Get-Member
    $wiDatabase = $wiObject.InvokeMethod("OpenDatabase", (Resolve-Path $Filename).Path, 0)
    # Open the Property-view
    $view = $wiDatabase.InvokeMethod("OpenView", "SELECT * FROM Property")
    $view.InvokeMethod("Execute")
    # Loop thru the table
    $r = $view.InvokeMethod("Fetch")
    while($r -ne $null)
    {
        # Add property and value to hash table
        $prop = $r.InvokeParamProperty("StringData",1)
        $value = $r.InvokeParamProperty("StringData",2)
        if ($prop -eq $PropertyName)
        {
            $msiProp = $value
        }
        # Fetch the next row
        $r = $view.InvokeMethod("Fetch")
    }
    $view.InvokeMethod("Close")     

    return $msiProp
}

function Connect-SCOServer{
<#
.SYNOPSIS
   Establishes a connection handle to the Orchestrator COM interface

.DESCRIPTION
    Establishes a connection handle to the Orchestrator COM interface that can be used
    with other functions that require authentication to succeed. This script must
    be run from the Orchestrator Management Server.

.PARAMETER UserName
    A valid user account with rights to perform actions against Orchestrator
    objects such as runbooks, folders, etc. Must be entered in the form of:
    DOMAIN\USERNAME

.PARAMETER Password
    The password associated with the provided user account.

.EXAMPLE
    $ConnectionHandle = Connect-SCOServer -Username "domain\user" -Password "Password"

.OUTPUTS
    System.Int32

#>

[CmdletBinding()]
	PARAM (
		[Parameter(Mandatory=$true,ValueFromPipelineByPropertyName=$true, ParameterSetName="SpecifyUser")]
        [ValidateNotNullOrEmpty()]
        [String] $UserName = $(throw "Provide a valid user account (domain\username)"),

		[Parameter(Mandatory=$true,ValueFromPipelineByPropertyName=$true, ParameterSetName="SpecifyUser")]
        [ValidateNotNullOrEmpty()]
        [String] $password = $(throw "Provide a password for the user account)")
	)

	PROCESS
    {
        try
        {
	        $oismgr = new-object -com OpalisManagementService.OpalisManager
			$ohandle = New-Object object
			$handle = $handle = New-Object Runtime.InteropServices.VariantWrapper($ohandle)
            $retval = $oismgr.Connect($UserName, $password, [ref]$handle)
            #Write-Host "     Handle: $($Handle)"
            if ($handle.GetType().FullName -eq "System.Int32")
            {
                return $handle
            }
            else
            {
                Write-Error "Unable to get a valid connection handle to Orchestrator!" -ErrorAction Stop
            }
	    }
        catch
        {
            Write-Error "Exception occurred in $($MyInvocation.MyCommand): `n$($_.Exception)"
            throw new-object system.formatexception
        }
    }
}

function Install-SCOIntegrationPack{
<#
.SYNOPSIS
  Registers and optionally deploys an Integration Pack to the current computer.
  Assumes the current computer is a Management Server (and a Designer/Runbook Server
  in the case of deploying the IP)

.DESCRIPTION

.PARAMETER Handle
  The handle to the COM interface created using New-SCOConnection

.PARAMETER Filename
  The path and filename of the OIP file to be imported

.PARAMETER Deploy
  Switch parameter used when you want to also deploy the IP.

.EXAMPLE
  Install-SCOIntegrationPack -OIPFile "C:\Files\Test.OIP" -Deploy

.OUTPUTS

#>
    [CmdletBinding()]
	PARAM (

		[Parameter(Mandatory=$true)]
        [Int] $Handle,

		[Parameter(Mandatory=$true)]
        [String] $Filename,

        [Parameter(Mandatory=$false)]
	    [Switch] $Deploy

	)
    BEGIN
    {
        $oismgr = new-object -com OpalisManagementService.OpalisManager -Strict
        #oismgr | Get-Member
        $sh = new-object -com shell.application
        LoadTypeData

        #Write-Host "     Handle: $($Handle)"
    }
    PROCESS
    {
        try
        {

            if ($(Test-Path $filename) -eq $false)
            {
                Write-Error "File Not Found!"
                return
            }
            [System.IO.FileInfo]$oipFile = gi $filename

            $extractDir = $(Join-Path -Path $oipFile.DirectoryName -ChildPath $oipFile.BaseName)
	        if (Test-Path $extractDir)
            {
                ri $extractDir -Recurse -Force
            }

	        $ipSourceDirObj = $sh.namespace($oipFile.DirectoryName)
	        $ipSourceDirObj.NewFolder($oipFile.BaseName)
            $extractDirObj = $sh.namespace($extractDir)

            Write-Debug "`n`nExtracting files from the OIP"
            $zipFileName = Join-Path $oipFile.DirectoryName "$($oipFile.BaseName).zip"
            if (Test-Path $zipFileName)
            {
                ri $zipFileName -Force
            }
            $zipFile = $oipFile.CopyTo($zipFileName)
	        $zipFileObj = $sh.namespace($zipFile.FullName)

	        $extractDirObj.CopyHere($zipFileObj.Items(),8 -and 16 -and 256)

            $commonFiles = ${Env:CommonProgramFiles(x86)}
            if ($null -eq $commonFiles)
            {
                $commonFiles = ${Env:CommonProgramFiles}
            }
            $PacksDir = Join-Path $commonFiles "Microsoft System Center 2012\Orchestrator\Management Server\Components\Packs"
            $ObjectsDir = Join-Path $commonFiles "Microsoft System Center 2012\Orchestrator\Management Server\Components\Objects"

            if ($(Test-Path $PacksDir) -eq $false)
            {
                Write-Error "Could not find $($PacksDir)"
                return
            }
            if ($(Test-Path $ObjectsDir) -eq $false)
            {
                Write-Error "Could not find $($ObjectsDir)"
                return
            }

            # Copy the MSI File to %Common Files%\Microsoft System Center 2012\Orchestrator\Management Server\Components\Objects
            $msiFile = $extractDirObj.self | gci | Where {$_.extension -eq ".msi"}

            $newMSIfile = $(Join-Path $ObjectsDir $msiFile.Name)
            if (Test-Path $newMSIfile)
            {
                ri $newMSIfile -Force
            }
	        $msiFile.CopyTo($newMSIfile)
            $productName = Get-MSIProperty -Filename $msiFile.FullName -Propertyname "ProductName"
            $productCode =  Get-MSIProperty -Filename $msiFile.FullName -Propertyname "ProductCode"

            #now use the MgmtService to install the IP
	        [System.IO.FileInfo]$capfile = $extractDirObj.self | gci | Where {$_.extension -eq ".cap"}
	        if ($capfile)
	        {
	            Write-Host "     Extracting $($capFile)"
	            $capXml = New-Object XML
	            $capXml.Load($capfile.Fullname)

	            # Need to modify the CAP file to add Product ID and Product Name because Deployment Manager
                # reads the MSI file for this and inserts it into the DB so it displays in the UI. The COM
                # interface does not do this, so it needs to be done manually if you want it displayed.
                #
	            #     <ProductName datatype="string">IP_SYSTEMCENTERDATAPROTECTIONMANAGER_1.0.OIP</ProductName>
	            #    <ProductID datatype="string">{9422FCC6-11C4-4827-AC49-C5FD352C8AA0}</ProductID>

                [Xml]$prodName = "<ProductName datatype=`"string`">$($ProductName)</ProductName>"
	            [Xml]$prodID = "<ProductID datatype=`"string`">$($ProductCode)</ProductID>"

	            $c = $capXml.ImportNode($prodName.ProductName, $true)
	            $d = $capXml.ImportNode($prodID.ProductID, $true)

	            $capXml.Cap.AppendChild($c)
	            $capXml.Cap.AppendChild($d) 

	            $oIPinfo = new-object object
	            $ipinfo = $ipinfo= New-Object Runtime.InteropServices.VariantWrapper($capXml.get_innerxml())
	            #Write-Host "     Importing Integration Pack $($capXml.get_innerxml())"
	            Write-Host "     Importing Integration Pack $($extractDir+'\\'+$capFile)"
	            $retval = $oismgr.AddIntegrationPack($Handle, [ref]$ipinfo)
		    }

            # Copy the OIP File to the %Common Files%\Microsoft System Center 2012\Orchestrator\Management Server\Components\Packs
            # directory and change the name to the GUID of the IP
            $productCodeOipFilename = "$($ProductCode).OIP"

            $newOIPfile = $(Join-Path $PacksDir $productCodeOipFilename)
            if (Test-Path $newOIPfile)
            {
                ri $newOIPfile -Force
            }
            write-host "new OIP file: $($newOIPfile)"
            $oipFile.CopyTo($newOIPfile)

            if ($PSBoundParameters.ContainsKey('Deploy') -eq $false)
            {
                return
            }

            if ($(Test-Path $newMSIfile) -eq $false)
	        {
                Write-Error "Could not find $($newMSIfile)"
                return
            }

	        Write-Verbose "Running msiexec to install  $($newMSIfile)"

            $proc = New-Object System.Diagnostics.Process
            $proc.StartInfo.FileName = "msiexec.exe"
            $proc.StartInfo.Arguments =  "/i `"$($newMSIfile)`" ALLUSERS=1 /q"
            $proc.Start() | out-null
            $proc.WaitForExit()

        }
        catch
        {
            Write-Error "Exception occurred in $($MyInvocation.MyCommand): `n$($_.Exception)"

        }

    }    

}

Invoke-Install-IP.ps1

Param (
    [Parameter(Mandatory=$true)]
    [ValidateNotNullOrEmpty()]
    [String] $OIPfile,
    [Parameter(Mandatory=$true)]
    [ValidateNotNullOrEmpty()]
    [String] $UserName,
    [Parameter(Mandatory=$true)]
    [ValidateNotNullOrEmpty()]
    [String] $UserPassWord
)

Process
{
    #
    . C:\DeployIP\Install-IP.ps1
    $conn = Connect-SCOServer –username $UserName -password $UserPassWord
    Install-SCOIntegrationPack –handle $conn –filename $OIPfile -Deploy
}

IIP.bat

@echo off
set currentDirectory=%~dp0
set OIPFILE=%1
set UserName=%2
set UserPassword=%3
echo %currentDirectory%
md "C:\Program Files (x86)\Common Files\Microsoft System Center 2012"
md "C:\Program Files (x86)\Common Files\Microsoft System Center 2012\Orchestrator"
md "C:\Program Files (x86)\Common Files\Microsoft System Center 2012\Orchestrator\Management Server"
md "C:\Program Files (x86)\Common Files\Microsoft System Center 2012\Orchestrator\Management Server\Components"
md "C:\Program Files (x86)\Common Files\Microsoft System Center 2012\Orchestrator\Management Server\Components\Packs"
md "C:\Program Files (x86)\Common Files\Microsoft System Center 2012\Orchestrator\Management Server\Components\Objects"

@pushd %currentDirectory%
start %SystemRoot%\syswow64\WindowsPowerShell\v1.0\powershell.exe set-executionpolicy remotesigned
ping localhost -n 20
echo "begin" %date%, %time%>>Install-IP.log
start %SystemRoot%\syswow64\WindowsPowerShell\v1.0\powershell.exe .\Invoke-Install-IP.ps1 %OIPFILE% %UserName% %UserPassword%
ping localhost -n 60
echo "end" %date%, %time%>>Install-IP.log
@popd