$ServerName=xxx

 $Database=xxx

 $UserID=xxx

 $Pwd=xxx

 $conn=new-object System.Data.SqlClient.SQLConnection

 $ConnectionString = "Server=$ServerName;Database=$Database;User ID=$UserID;Password=$pwd;Trusted_Connection=False;Connect Timeout=6000"

 $conn.ConnectionString=$ConnectionString

 $conn.Open()

 $Query="insert into 表名称(字段名, EventTime, EventType, EventId, Message) values(数值,N'$EventTime',N'$EventType',N'$EventId',N'$Message')"

  $cmd=new-object system.Data.SqlClient.SqlCommand($Query,$conn)

  $cmd.CommandTimeout=6000

  $cmd.ExecuteNonQuery()

  $conn.close()

 $Database = "xxx"

 $Server = "xxx"

 $Connection = New-Object System.Data.SQLClient.SQLConnection

 $Connection.ConnectionString = "server='$Server';database='$Database';trusted_connection=true;"

 $Connection.Open()

 $Command = New-Object System.Data.SQLClient.SQLCommand

 $Command.Connection = $Connection

 $insert="insert into 表名称(字段名,EventTime, EventType,EventSource, EventId, Message,RecordId) values(数值,N'$EventTime',N'$EventType',N'$TaskDisplayName',N'$EventId',N'$Message',N'$RecordId')"

   $cmd1=new-object system.Data.SqlClient.SqlCommand($insert,$Connection)

 $cmd1.CommandTimeout=6000

 $cmd1.ExecuteNonQuery()

 $Connection.Close()

 $Database = "xxx"

 $Server = "xxx"

 $ServerName="xxx"

 $Connection = New-Object System.Data.SQLClient.SQLConnection

 $Connection.ConnectionString = "server='$Server';database='$Database';trusted_connection=true;"

 $Connection.Open()

 $Command = New-Object System.Data.SQLClient.SQLCommand

 $Command.Connection = $Connection

  

 Add-PSSnapin SqlServerCmdletSnapin100

 Add-PSSnapin SqlServerProviderSnapin100

 $cmd=Invoke-Sqlcmd -ServerInstance $server -Database $Database -Query "select MAX(recordid) from [$Database].dbo.[$table] where [ServerName]='$serverName'"

 $max=$cmd.column1