如何获取windows网域下的计算机时间

最新推荐文章于 2024-07-10 17:08:52 发布

啃苹果的云

最新推荐文章于 2024-07-10 17:08:52 发布

阅读量718

点赞数

分类专栏：运维文章标签： powershell windows 需求

本文链接：https://blog.csdn.net/u013003966/article/details/72876693

版权

运维专栏收录该内容

1 篇文章 0 订阅

订阅专栏

需求：本地时间为域时间。想要获取其他windows计算机的时间与网域时间相比较并存入数据库。

编辑文件C:\IPList.txt

172.22.22.21:CNServer01
172.22.22.22:CNServer02

PowerShell脚本

$IPList = Get-Content "C:\IPList.txt"

$sqlServer = "DBSERVER"
$database = "TEST"
$UserName= 'test'
$Password= 'test'

$sqlConnection = New-Object System.Data.SqlClient.SqlConnection
$cnnString = "Server=$sqlServer;Database=$database;User ID=$UserName;Password=$Password;Trusted_Connection=False"
$sqlConnection.ConnectionString = $cnnString
$sqlCmd =New-Object System.Data.SqlClient.SqlCommand
$sqlCmd.Connection = $sqlConnection
$sqlCmd.Connection.Open()

foreach ($Server in $IPList)
{
try{
$IP=($Server -Split ":")[0]
$Name=($Server -Split ":")[1]
$info=GWmi win32_localtime -computername $IP
$DateTime=Get-Date
$dt= New-Object DateTime $info.year,$info.month,$info.day,$info.hour,$info.minute,$info.second 
$diff=(New-TimeSpan $DateTime -end $dt).TotalSeconds
$time1=$DateTime.ToString("yyyy-MM-dd HH:mm:ss")
$time2= $dt.ToString("yyyy-MM-dd HH:mm:ss")
$sqlCmd.CommandText = "INSERT INTO [dbo].[Time] (ServerName ,ServerTime ,DomainTime ,Diff) VALUES ('$Name','$time1','$time2','$diff')"
$sqlCmd.ExecuteNonQuery()
}
catch [exception]
{
$ErrMsg=$_.Exception.Message
print $ErrMsg
continue
}
}