首页 > 开发 > PowerShell > 正文

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

2020-10-29 20:56:01
字体:
来源:转载
供稿:网友

一、启用远程管理

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

运行Set-item wsman:localhost/client/trustedhosts 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:/SOFTWARE/Microsoft/Windows/CurrentVersion/Policies/System 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:/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"--因为取的服务器用户名都是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"        }     }$reportif($report -ne ""){  CreateAlter $report}

效果:

附:

xml文件格式:

1、computername.xml

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

2、cpdisk.xml

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

3、pwd.xml

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

完毕,欢迎拍砖!大笑

发表评论 共有条评论
用户名: 密码:
验证码: 匿名发表