Windows巡检SQL Server 指标脚本（PowerShell实现）

 

function WriteLog([string]  $content)
{
    #Write-Host $content
    $script:OutMessage += $content + "`r`n"
}

function sql($sqlText)
{
    $connection = new-object System.Data.SqlClient.SQLConnection("Data Source=(local)\SQLEXPRESSLYJ;Initial Catalog=master;User ID=sa;pwd=a12345678");
    $cmd = new-object System.Data.SqlClient.SqlCommand($sqlText, $connection);

    $connection.Open();
    $reader = $cmd.ExecuteReader()

    $results = @()
    while ( $reader.Read())
    {
        $row = @{ }
        for ($i = 0; $i -lt $reader.FieldCount; $i++)
        {
            $row[$reader.GetName($i)] = $reader.GetValue($i)
        }
        $results += new-object psobject -property $row
    }
    $connection.Close();

    $results
}

$sqlText = "select @@servername as Server_Name"
$Server_Name = sql($sqlText)
$