Журнал регистрации - как убрать запись в ЖР событий Сеанс Завершен

code|name
2|"BackgroundJob"

code|name
1|"VIRT-1C-01"

code|name
3|"_$Transaction$_.Begin"

code|name
4|"_$Transaction$_.Commit"

code|name
2|"_$Transaction$_.Finish"

changes: 41593705     total_changes: 41593705 

11.02.2016  09:37      7 288 039 424 1Cv8.lgd

11.02.2016  09:37       180 030 464 1Cv8.lgd

$PSVersionTable

CLRVersion              4.0.30319.34014                <- Нас интересует эта строчка !

Add-Type -Path "C:\Program Files\System.Data.SQLite\2010\bin\System.Data.SQLite.dll"

 $con = New-Object -TypeName System.Data.SQLite.SQLiteConnection
 $con.ConnectionString = "Data Source=C:\Vital\1cv9.lgd"
 $con.Open()

 $sql = $con.CreateCommand()
 $sql.CommandText = "ATTACH DATABASE 'C:\Vital\1cv8.lgd' as v8"
 $sql.ExecuteNonQuery()

 $sql = $con.CreateCommand()
 "AppCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS AppCodes AS SEL ECT * FR OM v8.AppCodes"
 $sql.ExecuteNonQuery()
 "ComputerCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS ComputerCodes AS SEL ECT * FR OM v8.ComputerCodes"
 $sql.ExecuteNonQuery()
 "ComputerToUserCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS ComputerToUserCodes AS SEL ECT * FR OM v8.ComputerToUserCodes"
 $sql.ExecuteNonQuery()
 "EventCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS EventCodes AS SEL ECT * FR OM v8.EventCodes"
 $sql.ExecuteNonQuery()
 "EventLogMetadata"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS EventLogMetadata AS SEL ECT * FR OM v8.EventLogMetadata"
 $sql.ExecuteNonQuery()
 "MetadataCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS MetadataCodes AS SEL ECT * FR OM v8.MetadataCodes"
 $sql.ExecuteNonQuery()
 "PrimaryPortCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS PrimaryPortCodes AS SEL ECT * FR OM v8.PrimaryPortCodes"
 $sql.ExecuteNonQuery()
 "SecondaryPortCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS SecondaryPortCodes AS SEL ECT * FR OM v8.SecondaryPortCodes"
 $sql.ExecuteNonQuery()
 "SessionDataCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS SessionDataCodes AS SEL ECT * FR OM v8.SessionDataCodes"
 $sql.ExecuteNonQuery()
 "SessionDataSplits"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS SessionDataSplits AS SEL ECT * FR OM v8.SessionDataSplits"
 $sql.ExecuteNonQuery()
 "SessionHosts"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS SessionHosts AS SEL ECT * FR OM v8.SessionHosts"
 $sql.ExecuteNonQuery()
 "SessionParamCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS SessionParamCodes AS SEL ECT * FR OM v8.SessionParamCodes"
 $sql.ExecuteNonQuery()
 "SessionUsers"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS SessionUsers AS SEL ECT * FR OM v8.SessionUsers"
 $sql.ExecuteNonQuery()
 "UserCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS UserCodes AS SEL ECT * FR OM v8.UserCodes"
 $sql.ExecuteNonQuery()
 "WorkServerCodes"
 $sql.CommandText = "CRE ATE   TABLE IF NOT EXISTS WorkServerCodes AS SEL ECT * FR OM v8.WorkServerCodes"
 $sql.ExecuteNonQuery()
 "-------------------------------------"
 $sql = $con.CreateCommand()
 $sql.CommandText = "SEL ECT * FR OM AppCodes WHERE name=@BackgroundJob"
 [void]$sql.Parameters.AddWithValue("@BackgroundJob", '"BackgroundJob"');
 $adapter = New-Object -TypeName System.Data.SQLite.SQLiteDataAdapter $sql
 $data = New-Object System.Data.DataSet
 [void]$adapter.Fill($data)

 $appCode = $data.tables.rows[0].code
 # DEBUG: Show recordset
 # $data.tables.rows


 $sql = $con.CreateCommand()
 $sql.CommandText = "SEL ECT * FR OM ComputerCodes WHERE (name=@Comp1 OR name=@Comp2)"
 [void]$sql.Parameters.AddWithValue("@Comp1", '"SMF-1C-01"');
 [void]$sql.Parameters.AddWithValue("@Comp2", '"SMF-1C-02"');
 $adapter = New-Object -TypeName System.Data.SQLite.SQLiteDataAdapter $sql
 $data = New-Object System.Data.DataSet
 [void]$adapter.Fill($data)

 # DEBUG: Show recordset
 # $data.tables.rows
 $computerCode1 = $data.tables.rows[0].code
 $computerCode2 = $data.tables.rows[1].code

 $sql = $con.CreateCommand()
 $sql.CommandText = "SEL ECT * FR OM EventCodes where name Like @Begin OR name Like @Commit OR name Like @Finish"
 [void]$sql.Parameters.AddWithValue("@Begin",  '%Begin%');
 [void]$sql.Parameters.AddWithValue("@Commit", '%Commit%');
 [void]$sql.Parameters.AddWithValue("@Finish", '%Finish%');
 $adapter = New-Object -TypeName System.Data.SQLite.SQLiteDataAdapter $sql
 $data = New-Object System.Data.DataSet
 [void]$adapter.Fill($data)

 # DEBUG: Show recordset
 # $data.tables.rows
 $eventCode1 = $data.tables.rows[0].code
 $eventCode2 = $data.tables.rows[1].code
 $eventCode3 = $data.tables.rows[2].code

 "Selecting EventLog (~5 min)"
 $sql = $con.CreateCommand()
 $sql.CommandText = "CRE ATE   TABLE EventLog AS SELECT * FR OM v8.EventLog WH ERE NOT ((eventCode=@eventCode1 OR eventCode=@eventCode2 OR eventCode=@eventCode3) AND (computerCode=@computerCode1 OR computerCode=@computerCode2) AND appCode=@appCode)"
 [void]$sql.Parameters.AddWithValue("@eventCode1", $eventCode1);
 [void]$sql.Parameters.AddWithValue("@eventCode2", $eventCode2);
 [void]$sql.Parameters.AddWithValue("@eventCode3", $eventCode3);
 [void]$sql.Parameters.AddWithValue("@computerCode1", $computerCode1);
 [void]$sql.Parameters.AddWithValue("@computerCode2", $computerCode2);
 [void]$sql.Parameters.AddWithValue("@appCode", $appCode);
 $sql.ExecuteNonQuery()

 Write-Host "Press any key to continue ..."
 $x = $host.UI.RawUI.ReadKey("NoEcho,IncludeKeyDown")

 $sql.Dispose()
 $con.Close()
 $con.Dispose()