Sqler 工具 CMd 更新
Sqler 工具 CMd 更新
sqler工具介绍（监控一）
sqler工具介绍（监控二）
sqler 工具介绍（报表）
sqler工具介绍（cmd）
新加入 CMD 功能
1 多线程远程创建文件夹
2 多线程远程操作服务
3 多线程远程 操作windows账户
4 多线程远程机器 加域、删域
5 多线程远程添加 防火墙端口
加域模块
1 # region JoinDomain
2 WorkFlow WFSqlerCmdJoinDomain
3 {
4 param ([array] $servers ,[string] $Domain
5 ,[string] $WmiAccount ,[string] $WmiPassWord
6 ,[array] $dns
7 ,[string] $Logfile = 'E:\Monitor\SqlerCmdLog')
8 foreach -parallel( $server in $servers )
9 {
10 inlinescript
11 {
12 try
13 {
14 $date =get- date
15 $PWD = ConvertTo-SecureString $using:WmiPassWord -AsPlainText - Force
16 $psc = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $using:WmiAccount , $PWD - ErrorAction Stop
17 $dpsc = New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList " $Using:Domain\$using:WmiAccount " , $PWD - ErrorAction Stop;
18 # #Set DNS
19 $IP =Get-WmiObject Win32_NetworkAdapterConfiguration -ComputerName $using:server -Credential $psc - ErrorAction Stop `
20 | Where{ $_ .IPEnabled -eq " TRUE " -and $_ .ipaddress -eq $using:server }
21 $Return = $IP .SetDNSServerSearchOrder( $Using:Dns );
22 Add-Computer -ComputerName $using:server -Credential $dpsc -DomainName $using:domain -LocalCredential $psc -Restart -Force - ErrorAction stop
23 " Succeed $using:server Begin:$date Server:$using:Server is join $using:Domain---- " |out -file -FilePath " $using:Logfile\SqlerCmdJoinDomainSucceed_$using:server.log " - Append
24 }
25 catch
26 {
27 $date =get- date
28 " Failed '$using:server' error info : " + $_ .Exception.Message|out -file -FilePath " $using:Logfile\SqlerCmdJoinDomainFailed_$using:server.log " - Append
29 }
30 }
31 }
32 inlinescript
33 {
34 if ((Test-Path -Path " $Using:Logfile\SqlerCmdJoinDomainFailed.log " )){Remove-Item -Path " $Using:Logfile\SqlerCmdJoinDomainFailed.log " }
35 if ((Test-Path -Path " $Using:Logfile\SqlerCmdJoinDomainSucceed.log " )){Remove-Item -Path " $Using:Logfile\SqlerCmdJoinDomainSucceed.log " }
36 Get-ChildItem -path $using:Logfile -recurse -include " *.log " | where { $_ .Name -match 'SqlerCmdJoinDomain' -and $_ .Name -match '_' } `
37 | ForEach -Object{ if ( $_ -match 'Failed'){Get-Content $_ |out -file -FilePath " $Using:Logfile\SqlerCmdJoinDomainFailed.log " -Append;Remove-Item -path $_ } Else {Get-Content $_ |out -file -FilePath " $Using:Logfile\SqlerCmdJoinDomainSucceed.log " -Append;Remove-Item -path $_ }}
38 }
39 }
40
41 # endregion
42 WFSqlerCmdJoinDomain $servers $domain $WmiAccount $WmiPassWord $dns
因牵涉到信息安全，部分信息作了处理
PS C:\Users\Administrator> cat E:\Monitor\SqlerCmdLog\SqlerCmdJoinDomainSucceed.log
Succeed 192.168.xx.xxx Begin:04/02/2013 11:50:22 Server:192.168.xx.xxx is join xxdb----
Succeed 192.168.xx.xxx Begin:04/02/2013 11:50:22 Server:192.168.xx.xx is join xxdb----
PS C:\Users\Administrator>
练一技,修百艺,而成于自然.
分类: Tool:Sqler
作者： Leo_wl
出处： http://www.cnblogs.com/Leo_wl/
本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接，否则保留追究法律责任的权利。
版权信息声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did46406