问在PowerShell中对WID运行sqlcmd

EN

$SQLPath = "C:\Users\<username>\Documents\SQL Server Management Studio\"
$SQLfile = "SUSDB-ReIndex.sql"
$WsusSvrs = ("WSUS-Site1","WSUS-Site7","WSUS-Site13","WSUS-Site14","WSUS-Site15")
$ErrorActionPreference = "Stop"
$results = @()

Foreach ($WSUSSvr in $WSUSSvrs) {
    Try {
        $sess = New-PSSession -ComputerName $WSUSSvr -EnableNetworkAccess -ErrorAction Stop
    }
    Catch {
        continue;
    } 

    $output = Invoke-Command -Session $sess -ScriptBlock {
        If (-NOT ([Security.Principal.WindowsPrincipal][Security.Principal.WindowsIdentity]::GetCurrent()).IsInRole([Security.Principal.WindowsBuiltInRole] "Administrator")) {   
            $arguments = "& '" + $myinvocation.mycommand.definition + "'"
            Start-Process powershell -Verb runAs -ArgumentList $arguments
            Break
        } 

        If((Get-Command SQLcmd.exe -ErrorAction SilentlyContinue)-eq "") {
            $NoSQLCmd = new-object System.IO.FileNotFoundException("SQLcmd is not Installed on this machine, please install the appropriate version and try again")
            Throw $NoSQLCmd
        }

        $Output = New-Object psobject
        $OSVerStr = (Gwmi win32_operatingsystem).version.split(".")
        [single]$OS = [convert]::ToSingle(($OSVerStr[0],$OSVerStr[1] -join "."))
        $Output | Add-Member -MemberType NoteProperty -Name OSVer -Value $OS

        if ($OS -gt 6.1) {
            $conStr = "\\.\pipe\Microsoft##WID\tsql\query"
        }
        Else {
            $conStr = 'np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query'
        }

        if(Test-Path "$using:SQLPath\$Using:SQLfile") {
            $cmd = "sqlcmd.exe -S $ConStr -i '$Using:SQLPath\$Using:SQLfile' -d 'SUSDB' -E -o 'C:\temp \$Using:WSUSSvr-reindexout.txt'"
            Invoke-Expression $cmd
            $output | Add-Member -MemberType NoteProperty -Name Message -Value "done"
        }
        else {
            $output | Add-Member -MemberType NoteProperty -Name Message -Value "Unable to find $Using:sqlfile"
        }
        $Output
    } -ArgumentList $SQLPath,$SQLfile,$WSUSSvr

    $results += $output

    if(test-path "\\$wsussvr\C$\temp\$WSUSSvr-reindexout.txt") {
        cp "\\$wsussvr\C$\temp\$WSUSSvr-reindexout.txt" "D:\wsus-reports\" -Force
    }

    If( $sess.State -eq "Opened" ) { Remove-PSSession $sess }
}

$results | ft