$server = "."$uid = "sa"$db="master"$pwd="數(shù)據(jù)庫(kù)sa密碼"$mailprfname = "test" ---需要跟select name FROM msdb.dbo .sysmail_profile一致$recipients = "接收郵箱，多個(gè)用；隔開" $subject = "郵件標(biāo)題"$computernamexml = "E:/powershell/computername.xml"$alter_xml = "E:/powershell/cpdisk.xml"$pwd_xml = "E:/powershell/pwd.xml"function GetServerName($xmlpath){  $xml = [xml] (Get-Content $xmlpath)  $return = New-Object Collections.Generic.List[string]  for($i = 0;$i -lt $xml.computernames.ChildNodes.Count;$i++)  {    if ( $xml.computernames.ChildNodes.Count -eq 1)    {      $cp = [string]$xml.computernames.computername    }    else    {      $cp = [string]$xml.computernames.computername[$i]    }    $return.Add($cp.Trim())  }  $return}function GetAlterCounter($xmlpath){  $xml = [xml] (Get-Content $xmlpath)  $return = New-Object Collections.Generic.List[string]  $list = $xml.counters.Counter  $list}function Getpwd($xmlpath){  $xml = [xml] (Get-Content $xmlpath)  $returnpwd = New-Object Collections.Generic.List[string]  for($i = 0;$i -lt $xml.pwd.ChildNodes.Count;$i++)  {    if ( $xml.pwds.ChildNodes.Count -eq 1)    {      $pw = [string]$xml.pwd.password    }    else    {      $pw = [string]$xml.pwd.password[$i]    }    $returnpwd.Add($pw.Trim())  }  $returnpwd}function CreateAlter($message){  $SqlConnection = New-Object System.Data.SqlClient.SqlConnection   $CnnString ="Server = $server; Database = $db;User Id = $uid; Password = $pwd"  $SqlConnection.ConnectionString = $CnnString   $CC = $SqlConnection.CreateCommand();   if (-not ($SqlConnection.State -like "Open")) { $SqlConnection.Open() }     $cc.CommandText=      " EXEC msdb..sp_send_dbmail        @profile_name = '$mailprfname'      ,@recipients = '$recipients'      ,@body = '$message'      ,@subject = '$subject'      "  $cc.ExecuteNonQuery()|out-null   $SqlConnection.Close();}$names = GetServerName($computernamexml)$pfcounters = GetAlterCounter($alter_xml)$upwd = Getpwd($pwd_xml)$report = ""for($m=0;$m -lt $names.count;$m++){$cp=$names[$m]$p=New-Object -TypeName System.Collections.ArrayList$uname="administrator"--因?yàn)槿〉姆?wù)器用戶名都是administrator，如果每臺(tái)機(jī)器不一樣，可以放在XML等文件中讀取$pw=$upwd[$m]$upassword=convertto-securestring $pw -AsplainText -force;foreach ($pfc in $pfcounters){  $filter="deviceID='"+$pfc.get_InnerText().Trim()+"'"   #$Disk =get-wmiobject win32_logicaldisk -computername $cp -Filter $filter  #$counter=$Disk.Freespace/1024MB  $cred=new-object system.management.automation.PSCredential($uname,$upassword);  $counter=(get-wmiobject -credential $cred -class win32_logicaldisk -computername $cp -filter $filter).Freespace/1024MB  $total=(get-wmiobject -credential $cred -class win32_logicaldisk -computername $cp -filter $filter).Size/1024MB  #$pfc = $pfcounters[$i]  $path = "機(jī)器名："+$cp+"; 盤符："+$pfc.get_InnerText()  $diskFree=";總磁盤空間大小為:"+[math]::truncate($total).ToString()+"G;當(dāng)前剩余空間大小為："+[math]::truncate($counter).ToString()+"G!"        $item = "{0} {1} " -f $path,$diskFree  $report += $item + "`n"        }     }$reportif($report -ne ""){  CreateAlter $report}

<computername>    <computername>    test    </computername></computernames>

<Counters>    <Counter>C:</Counter>    <Counter>D:</Counter></Counters>

<pwd>    <password>     helloworld     </password><pwd>