PowerShell 服务ping检测mysql版

PowerShell 服务ping检测mysql版

直接上代码

#ping测试后台程序
#1.0 实现ping统计，错误日志功能 2012-11-13
[void][system.reflection.Assembly]::LoadFrom("C:\v2\mysql.data.dll")
$connection = New-Object MySql.Data.MySqlClient.MySqlConnection
$connection.ConnectionString = "host=172.16.10.103;uid=ping;pwd=kLvs7V_zIcT6ny0V"
$command = New-Object MySql.Data.MySqlClient.MySqlCommand($sql,$connection)
$command.CommandTimeout=600
$command.CommandText="select * from ping.host"
$dt1=New-Object System.Data.DataTable
$dt2=New-Object System.Data.DataTable
$da=New-Object MySql.Data.MySqlClient.MySqlDataAdapter($command)
$null=$da.Fill($dt1) 
$command.CommandText="select * from ping.pingstat limit 1"
$da=New-Object MySql.Data.MySqlClient.MySqlDataAdapter($command)
$null=New-Object MySql.Data.MySqlClient.MySqlCommandBuilder($da)
$null=$da.Fill($dt2)



$getping={
   param($daddr)
$time=(get-date)
$ping = New-Object System.Net.NetworkInformation.Ping
$ping.send($daddr,4000)|select @{
   N="DAddr";E={
   $_.Address}},@{
   N="DName";