一、启用远程管理
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测试是否可以连接远程服务器,如图:
连接成功的状态如下所示:
下面就可以来取每个服务器的磁盘空间了
二、脚本
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
|
$server = "." $uid = "sa" $db = "master" $pwd = "数据库sa密码" $mailprfname = "test" ---需要跟 select name FROM msdb.dbo .sysmail_profile一致 $recipients = "接收邮箱,多个用;隔开" $subject = "邮件标题" $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" } } $report if( $report -ne "" ) { CreateAlter $report } |
效果:
附:
xml文件格式:
1、computername.xml
1
2
3
4
5
|
< computername > < computername > test </ computername > </ computernames > |
2、cpdisk.xml
1
2
3
4
|
< Counters > < Counter >C:</ Counter > < Counter >D:</ Counter > </ Counters > |
3、pwd.xml
1
2
3
4
5
|
< pwd > < password > helloworld </ password > < pwd > |
完毕,欢迎拍砖!大笑