internal/functions/Invoke-ManagedComputerCommand.ps1
|
function Invoke-ManagedComputerCommand { <# .SYNOPSIS Runs wmi commands against a target system. .DESCRIPTION Runs wmi commands against a target system. Either directly or over PowerShell remoting. .PARAMETER ComputerName The target to run against. Must be resolvable. .PARAMETER Credential Credentials to use when using PowerShell remoting. .PARAMETER ScriptBlock The scriptblock to execute. Use $wmi to access the smo wmi object. Must not include a param block! .PARAMETER ArgumentList The arguments to pass to your scriptblock. Access them within the scriptblock using the automatic variable $args .PARAMETER EnableException Left in for legacy reasons. This command will throw no matter what #> [CmdletBinding()] param ( [Parameter(Mandatory)] [Alias("Server")] [dbainstanceparameter]$ComputerName, [PSCredential]$Credential, [Parameter(Mandatory)] [scriptblock]$ScriptBlock, [string[]]$ArgumentList, [switch]$EnableException # Left in for legacy but this command needs to throw ) $computer = $ComputerName.ComputerName $null = Test-ElevationRequirement -ComputerName $computer -EnableException $true $resolved = Resolve-DbaNetworkName -ComputerName $computer -Turbo $ipaddr = $resolved.IpAddress $ArgumentList += $ipaddr [scriptblock]$setupScriptBlock = { $ipaddr = $args[$args.GetUpperBound(0)] # Just in case we go remote, ensure the assembly is loaded [void][System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SqlWmiManagement') $wmi = New-Object Microsoft.SqlServer.Management.Smo.Wmi.ManagedComputer $ipaddr $null = $wmi.Initialize() } $prescriptblock = $setupScriptBlock.ToString() $postscriptblock = $ScriptBlock.ToString() $scriptblock = [ScriptBlock]::Create("$prescriptblock $postscriptblock") Write-Message -Level Verbose -Message "Connecting to SQL WMI on $computer." try { Invoke-Command2 -ScriptBlock $ScriptBlock -ArgumentList $ArgumentList -Credential $Credential -ErrorAction Stop } catch { Write-Message -Level Verbose -Message "Local connection attempt to $computer failed. Connecting remotely." # For surely resolve stuff, and going by default with kerberos, this needs to match FullComputerName $hostname = $resolved.FullComputerName Invoke-Command2 -ScriptBlock $ScriptBlock -ArgumentList $ArgumentList -ComputerName $hostname -Credential $Credential -ErrorAction Stop } } |