PowerShell入门教程推荐和常用代码片段

1# 要在管理员下运行，输入的域账号也要是域的管理员权限
2
3Reset-ComputerMachinePassword -Server "Domain.com" -Credential Domain\Admin

 1function Get-LocalIP
 2{
 3    # 获取 本机IP 防止拿不到IP用了多次IP获取
 4
 5    # IP地址不为空的，网关也不为空的
 6    $Local_IP_Temp = (
 7        Get-WmiObject -Class Win32_NetworkAdapterConfiguration |
 8        Where-Object { $NULL -ne $_.IPAddress -and $_.DefaultIPGateway -ne $Null } |
 9        Select-Object IPAddress
10    ).IPAddress[0] 
11    
12    # 按要求自行修改
13    
14    # IP地址不为空的，网关符合 "*.*.*.1" 格式的
15    #$Local_IP_Temp = (   
16    #    Get-WmiObject -Class Win32_NetworkAdapterConfiguration | 
17    #    Where-Object { $NULL -ne $_.IPAddress -and $_.DefaultIPGateway -like "*.*.*.1" } |
18    #    Select-Object IPAddress
19    #).IPAddress[0]
20
21    return $Local_IP_Temp
22}
23
24
25# 用法示例
26
27$IP = Get-LocalIP
28Write-Host $IP

 1# 函数 操作SQL
 2function Open-SQL {
 3	# 传入SQL数据库名和SQL语句
 4    param (
 5        $SQL_Database_arg,
 6        $SQL_Commandtext_arg
 7    )
 8
 9    #配置SQL服务器信息
10    $SQL_Server = "192.168.x.x"
11    $SQL_UserName = "administrator"
12    $SQL_Password = "password"
13    $SQL_Database = $SQL_Database_arg
14    $SQL_Commandtext = $SQL_Commandtext_arg
15
16    #创建SQL连接对象
17    $SQL_Connection = New-Object System.Data.SqlClient.SqlConnection
18
19    #使用账号连接SQL
20    $SQL_Connection.ConnectionString = "Data Source=$SQL_Server; Initial Catalog=$SQL_Database; user id=$SQL_UserName; pwd=$SQL_Password"
21
22    #打开数据库连接
23    try {
24        $SQL_Connection.Open()
25    }
26    catch {
27        # 如果打开失败的话，提前返回 "Unable to open SQL" 无法打开SQL
28        return "Unable to open SQL"
29    }
30
31    #创建SQL命令对象
32    $SQL_Command = New-Object System.Data.SqlClient.SqlCommand
33    $SQL_Command.Connection = $SQL_Connection
34    $SQL_Command.Commandtext = $SQL_Commandtext
35
36    #创建DataSet和 SQL Server之间的桥接器
37    $SQL_DataAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
38    $SQL_DataAdapter.SelectCommand = $SQL_Command
39
40    #创建DataSet
41    $Data_set = New-Object data.dataset
42    $SQL_DataAdapter.Fill($Data_set) | Out-Null
43    #$Data_set.Tables | Format-Table -Auto
44
45    #关闭数据库连接
46    $SQL_Connection.Close()
47
48    #----------------------
49
50    # 得到一份类似表的 DataRow 数据
51    $SQL_Data_Temp = $Data_set.Tables[0]
52
53    # 返回数据
54    return $SQL_Data_Temp
55}
56
57
58# 用法示例
59
60# 获取SQL
61$IP_SQL_info = Open-SQL -SQL_Database_arg "Auto_Install_Soft" -SQL_Commandtext_arg "SELECT * FROM dbo.Auto_Install_Soft WHERE [IP地址] = '$IP'"
62
63# 更新SQL数据
64Open-SQL -SQL_Database_arg "Auto_Install_Soft" -SQL_Commandtext_arg "UPDATE dbo.Auto_Install_Soft SET [排除安装] = '', [计划日期] = '2022-09-22', [最后限期] = '2022-12-30', [千牛] = 'True' WHERE [IP地址] = '$IP'"

 1# 要改的IP地址
 2$IP_address = "10.10.3.222"
 3
 4# 要改的子网掩码
 5$Subnet_mask = "255.255.255.0"
 6
 7# 要改的网关地址（这里是直接偷懒拿了IP地址，取了前3段，加上"1" 来生成的网关，可以直接定义 $Default_Gateway）
 8$IP_address -match "^\d+.\d+.\d+." | Out-Null
 9$Default_Gateway = $matches[0] + "1"
10
11# 要改的DNS地址
12$DnsOrderList = @("192.168.4.6", "192.168.4.7")
13
14# 打印一次看看要改的内容
15Write-Host $IP_address
16Write-Host $Subnet_mask
17Write-Host $Default_Gateway
18Write-Host $DnsOrderList
19
20
21Start-Sleep -Seconds 5
22
23
24# 获取网卡, IP已启用，而且网关不为空
25$Wmi_Win32_Network = Get-WmiObject -Class Win32_NetworkAdapterConfiguration | Where-Object { $_.IPEnabled -ne $False -and $_.DefaultIPGateway -ne $Null}
26
27# 只有1张符合条件的网卡才会修改IP
28if ($Wmi_Win32_Network.Count -eq 1) {
29    $Wmi_Win32_Network.EnableStatic($IP_address, $Subnet_mask)
30    $Wmi_Win32_Network.SetGateways($Default_Gateway, 1)
31    $Wmi_Win32_Network.SetDNSServerSearchOrder($DnsOrderList)
32
33    # 改完后60秒关机
34    Shutdown /s /t 60
35}
36
37# 用法示例