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

# 要在管理员下运行，输入的域账号也要是域的管理员权限

Reset-ComputerMachinePassword -Server "Domain.com" -Credential Domain\Admin

function Get-LocalIP
{
    # 获取 本机IP 防止拿不到IP用了多次IP获取

    # IP地址不为空的，网关也不为空的
    $Local_IP_Temp = (
        Get-WmiObject -Class Win32_NetworkAdapterConfiguration |
        Where-Object { $NULL -ne $_.IPAddress -and $_.DefaultIPGateway -ne $Null } |
        Select-Object IPAddress
    ).IPAddress[0] 
    
    # 按要求自行修改
    
    # IP地址不为空的，网关符合 "*.*.*.1" 格式的
    #$Local_IP_Temp = (   
    #    Get-WmiObject -Class Win32_NetworkAdapterConfiguration | 
    #    Where-Object { $NULL -ne $_.IPAddress -and $_.DefaultIPGateway -like "*.*.*.1" } |
    #    Select-Object IPAddress
    #).IPAddress[0]

    return $Local_IP_Temp
}


# 用法示例

$IP = Get-LocalIP
Write-Host $IP

# 函数 操作SQL
function Open-SQL {
	# 传入SQL数据库名和SQL语句
    param (
        $SQL_Database_arg,
        $SQL_Commandtext_arg
    )

    #配置SQL服务器信息
    $SQL_Server = "192.168.x.x"
    $SQL_UserName = "administrator"
    $SQL_Password = "password"
    $SQL_Database = $SQL_Database_arg
    $SQL_Commandtext = $SQL_Commandtext_arg

    #创建SQL连接对象
    $SQL_Connection = New-Object System.Data.SqlClient.SqlConnection

    #使用账号连接SQL
    $SQL_Connection.ConnectionString = "Data Source=$SQL_Server; Initial Catalog=$SQL_Database; user id=$SQL_UserName; pwd=$SQL_Password"

    #打开数据库连接
    try {
        $SQL_Connection.Open()
    }
    catch {
        # 如果打开失败的话，提前返回 "Unable to open SQL" 无法打开SQL
        return "Unable to open SQL"
    }

    #创建SQL命令对象
    $SQL_Command = New-Object System.Data.SqlClient.SqlCommand
    $SQL_Command.Connection = $SQL_Connection
    $SQL_Command.Commandtext = $SQL_Commandtext

    #创建DataSet和 SQL Server之间的桥接器
    $SQL_DataAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
    $SQL_DataAdapter.SelectCommand = $SQL_Command

    #创建DataSet
    $Data_set = New-Object data.dataset
    $SQL_DataAdapter.Fill($Data_set) | Out-Null
    #$Data_set.Tables | Format-Table -Auto

    #关闭数据库连接
    $SQL_Connection.Close()

    #----------------------

    # 得到一份类似表的 DataRow 数据
    $SQL_Data_Temp = $Data_set.Tables[0]

    # 返回数据
    return $SQL_Data_Temp
}


# 用法示例

# 获取SQL
$IP_SQL_info = Open-SQL -SQL_Database_arg "Auto_Install_Soft" -SQL_Commandtext_arg "SELECT * FROM dbo.Auto_Install_Soft WHERE [IP地址] = '$IP'"

# 更新SQL数据
Open-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'"

# 要改的IP地址
$IP_address = "10.10.3.222"

# 要改的子网掩码
$Subnet_mask = "255.255.255.0"

# 要改的网关地址（这里是直接偷懒拿了IP地址，取了前3段，加上"1" 来生成的网关，可以直接定义 $Default_Gateway）
$IP_address -match "^\d+.\d+.\d+." | Out-Null
$Default_Gateway = $matches[0] + "1"

# 要改的DNS地址
$DnsOrderList = @("192.168.4.6", "192.168.4.7")

# 打印一次看看要改的内容
Write-Host $IP_address
Write-Host $Subnet_mask
Write-Host $Default_Gateway
Write-Host $DnsOrderList


Start-Sleep -Seconds 5


# 获取网卡, IP已启用，而且网关不为空
$Wmi_Win32_Network = Get-WmiObject -Class Win32_NetworkAdapterConfiguration | Where-Object { $_.IPEnabled -ne $False -and $_.DefaultIPGateway -ne $Null}

# 只有1张符合条件的网卡才会修改IP
if ($Wmi_Win32_Network.Count -eq 1) {
    $Wmi_Win32_Network.EnableStatic($IP_address, $Subnet_mask)
    $Wmi_Win32_Network.SetGateways($Default_Gateway, 1)
    $Wmi_Win32_Network.SetDNSServerSearchOrder($DnsOrderList)

    # 改完后60秒关机
    Shutdown /s /t 60
}

# 用法示例