powershell远程管理服务器磁盘空间的实现代码

一、启用远程管理

1、将管理服务器的trusthost列表改为*

运行Set-item wsman:localhostclienttrustedhosts –value *

2、在远程服务器上运行Enable-PSremoting

注：

在本地服务器上以Administrator运行“Enable-Psremoting 、 Winrm Quickconfig 、 Set-WSManQuickConfig”，均提示“访问被拒绝”，可能的原因如下：

1.在工作组计算机上，确认组策略： secpol.msc > Local Policies > Security Options > Network Access: Sharing and security model for local accounts - change to classic

2.修改注册表：Set-ItemProperty –Path HKLM:SOFTWAREMicrosoftWindowsCurrentVersionPoliciesSystem –Name LocalAccountTokenFilterPolicy –Value 1 –Type DWord

3.确认WinRM服务是否正在运行，Windows Firewall服务是否正在运行，网络位置是否不是“公用”，如果要启用PS远程管理，此时网络位置不能被设置为public，因为Windows 防火墙例外不能在网络位置是public时被启用。

4.Telnet localhost 47001是否可以连通

5.运行 winrm get winrm/config 是否会提示“访问被拒绝”

6.Administrator密码不能为空

远程启用开启之后可以在cmd命令窗口输入wbemtest测试是否可以连接远程服务器，如图：

连接成功的状态如下所示：

下面就可以来取每个服务器的磁盘空间了

二、脚本

$server = "." $uid = "sa" $db="master" $pwd="数据库sa密码" $mailprfname = "test" ---需要跟select name FROM msdb.dbo .sysmail_profile一致 $recipients = "接收邮箱，多个用；隔开" $subject = "邮件标题" $computernamexml = "E:powershellcomputername.xml" $alter_xml = "E:powershellcpdisk.xml" $pwd_xml = "E:powershellpwd.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"--因为取的服务器用户名都是administrator，如果每台机器不一样，可以放在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 = "机器名："+$cp+"; 盘符："+$pfc.get_InnerText() $diskFree=";总磁盘空间大小为:"+[math]::truncate($total).ToString()+"G;当前剩余空间大小为："+[math]::truncate($counter).ToString()+"G!" $item = "{0} {1} " -f $path,$diskFree $report += $item + "`n" } } $report if($report -ne "") { CreateAlter $report }

效果：

附：

xml文件格式：

1、computername.xml

2、cpdisk.xml

3、pwd.xml

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

完毕，欢迎拍砖！大笑