主页 / server / 问题 / 633781
Accepted
JJJJNR
Asked: 2014-10-07 00:15:56 +0800 CST

来自 CSV 的页面文件大小

  • 772

我有以下脚本，它检查远程服务器上的页面文件大小，是否可以针对主机名的 CSV 文件运行它？

clear 

$strComputer="computername"

$PageFile=Get-WmiObject Win32_PageFile -ComputerName $strComputer 
Write-Host "Page File Size in MB: " ($PageFile.Filesize/(1024*1024))

$colItems=Get-WmiObject Win32_PhysicalMemory -Namespace root\CIMv2 -ComputerName $strComputer 
$total=0 
foreach ($objItem in $colItems) {
    $total=$total+ $objItem.Capacity 
}

$isPAEEnabled =Get-WmiObject Win32_OperatingSystem -ComputerName $strComputer
windows-server-2008

1 个回答

  1. Best Answer

    如果您有一个带有“主机名”列的 Csv 文件，如下所示，您可以使用Import-Csv.

    示例 servers.csv 文件：

    Id,Hostname,"ServerRole"
123,Server1,"Web Server"
124,Server2,"Web Server"
131,Server3,"App Server"
132,Server4,"App Server"

    foreach使用并Import-Csv完成您正在尝试执行的操作的脚本：

    # Clear the screen
Clear-Host

# Import the Hostname values from the CSV file
$ComputerNames = Import-Csv -Path "C:\servers.csv" | Select-Object -ExpandProperty "Hostname"

# Empty array to hold the results
$ResultSet = @()

# query each computer for their Page file and memory details
foreach($strComputer in $ComputerNames)
{
    $PageFile=Get-WmiObject Win32_PageFile -ComputerName $strComputer 
    $PFSize = ($PageFile.Filesize/(1024*1024))

    $colItems=Get-WmiObject Win32_PhysicalMemory -Namespace root\CIMv2 -ComputerName $strComputer 
    $total=0 
    foreach ($objItem in $colItems) {
        $total = $total + $objItem.Capacity 
    }

    $isPAEEnabled =Get-WmiObject Win32_OperatingSystem -ComputerName $strComputer

    # Store all the details in a temporary hashtable
    $PageFileDetails = @{ 
        "ComputerName" = $strComputer
        "PagefileInMB" = $PFSize
        "Memory"       = $total
        "PAEEnabled"   = $isPAEEnabled
    }

    # Create a new object with the properties we defined in the hashtable and add it to the result
    $ResultSet += New-Object psobject -Property $PageFileDetails
}

# the host application will print out the details for each computer on the screen
$ResultSet

    该$ResultSet变量现在包含一个PSObject表示查询的每台计算机，每台计算机都有一个“ComputerName”、“PagefileInMB”、“Memory”和“PAEEnabled”属性。

    您现在可以轻松找到禁用 PAE 的计算机：

    $ResultSet | Where-Object {$_.PAEEnabled -eq $False}
    • 1

相关问题