無法將IIS結果匯出到CSV

我創建了一個腳本來從多個服務器獲取所有 IIS 站點和應用程式池詳細資訊，該腳本按預期作業正常，但我無法將結果匯出到 CSV 檔案。

如果有人建議我如何將輸出詳細資訊匯出到 CSV 檔案，這將很有幫助。

代碼

#Import-Module -Name WebAdministration

$Computers = Get-Content "C:\Desktop\Scripts\Servers.txt"

foreach ($server in $Computers) {

    $iis = Get-WmiObject Win32_Service -Filter "Name = 'IISADMIN'" -ComputerName $server

    if ($iis.State -eq 'Running') 
    { 
    $details = Write-Host "IIS is running on $server" -ForegroundColor Green 
    #Chandu
    Invoke-Command -ComputerName $Computers -ScriptBlock {
    # Changed to newer IISAdministration Module to match Get-IISAppPool
    $Websites = Get-IISSite

    foreach ($Website in $Websites) {

        $AppPool = Get-IISAppPool -Name $Website.Applications[0].ApplicationPoolName
        #$Website.ApplicationPool
        [PSCustomObject]@{
            Server_Name = $env:COMPUTERNAME  '.'  $env:USERDNSDOMAIN
            Website_Name                  = $Website.Name
            Website_Id                    = $Website.Id -join ';'
            Website_State                 = $Website.State -join ';'
            Website_PhysicalPath          = $Website.PhysicalPath -join ';'
            Website_Bindings              = $Website.Bindings.Collection -join ';'
            Website_Attributes            = ($Website.Attributes | ForEach-Object { $_.name   "="   $_.value }) -join ';'
            AppPool_Name                  = $AppPool.Name -join';'
            AppPool_State                 = $AppPool.State -join ';'
            AppPool_ManagedRuntimeVersion = $AppPool.ManagedRuntimeVersion -join ';'
            AppPool_ManagedPipelineMode   = $AppPool.ManagedPipelineMode -join ';'
            AppPool_StartMode             = $AppPool.StartMode -join ';'
          }
        } Export-csv -Path "C:\Desktop\Scripts\IISite_App-pool_Details.csv" -Append
      }    
   }
} 
#Export-Excel -Append -Path C:\Desktop\Scripts\IISite_App-pool_Details.xlsx -AutoSize -BoldTopRow

uj5u.com熱心網友回復：

您可以將開關添加-HideComputerName到Invoke-Commandcal，但輸出仍然會添加屬性“RunspaceId”和“PSShowComputerName”。

如果您不想要這些，可以從結果中取消選擇它們，例如

$iis = Get-WmiObject Win32_Service -Filter "Name = 'IISADMIN'" -ComputerName $server

if ($iis.State -eq 'Running') { 
    $details = Write-Host "IIS is running on $server" -ForegroundColor Green 
    #Chandu
    $result = Invoke-Command -ComputerName $Computers -ScriptBlock {
        # Changed to newer IISAdministration Module to match Get-IISAppPool
        $Websites = Get-IISSite

        foreach ($Website in $Websites) {
            $AppPool = Get-IISAppPool -Name $Website.Applications[0].ApplicationPoolName
            #$Website.ApplicationPool
            [PSCustomObject]@{
                Server_Name                   = $env:COMPUTERNAME  '.'  $env:USERDNSDOMAIN
                Website_Name                  = $Website.Name
                Website_Id                    = $Website.Id -join ';'
                Website_State                 = $Website.State -join ';'
                Website_PhysicalPath          = $Website.Applications["/"].VirtualDirectories["/"].PhysicalPath -join ';'
                Website_Bindings              = (Get-Website -Name $Website.Name).bindings.Collection join ';'
                Website_Attributes            = ($Website.Attributes | ForEach-Object { $_.name   "="   $_.value }) -join ';'
                AppPool_Name                  = $AppPool.Name -join';'
                AppPool_State                 = $AppPool.State -join ';'
                AppPool_ManagedRuntimeVersion = $AppPool.ManagedRuntimeVersion -join ';'
                AppPool_ManagedPipelineMode   = $AppPool.ManagedPipelineMode -join ';'
                AppPool_StartMode             = $AppPool.StartMode -join ';'
            }
        } 
    }
    # remove the extra properties Invoke-Command added
    $result = $result | Select-Object * -ExcludeProperty 'PSComputerName','RunspaceId','PSShowComputerName'
    # save the result as CSV file
    $result | Export-Csv -Path "C:\Desktop\Scripts\IISite_App-pool_Details.csv" -NoTypeInformation        
}

PS您的代碼沒有顯示您初始化變數的位置$Computers..

標籤：电源外壳 iis 应用程序池

上一篇：在C#和PowerShell之間出現雙引號問題

下一篇：如何使用Powershell/XAML創建閃爍按鈕？