Modify the following lines:
- $dataSource = “InstanceBDD”
- $user = “usrlandeskRead”
- $PassSQL = ‘DeskLDMSread$1’
- $database = “LDMS17”
$query = "SELECT * FROM [LDMS].[dbo].[LD_TASK]"- $mycreds = Get-Credential -Credential “domaine\dwuibail_adm”
- $ldWS = New-WebServiceProxy -uri http://serverlandesk.leblogosd.lan/MBSDKService/MsgSDK.asmx?WSDL -Credential $mycreds
$Retentionday = 30
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 | $dataSource = "InstanceBDD"$user = "usrlandeskRead"$PassSQL = 'password'$database = "LDMS"$connectionString = "Server=$dataSource;uid=$user; pwd=$PassSQL;Database=$database;Integrated Security=False;"$connection = New-Object System.Data.SqlClient.SqlConnection$connection.ConnectionString = $connectionString$connection.Open()$query = "SELECT * FROM [LDMS].[dbo].[LD_TASK]"$command = $connection.CreateCommand()$command.CommandText = $query$result = $command.ExecuteReader()$table = new-object System.Data.DataTable$table.Load($result)$currentdate = get-date$mycreds = Get-Credential -Credential "domaine\dwuibail_adm"$ldWS = New-WebServiceProxy -uri http://serverlandesk.leblogosd.lan/MBSDKService/MsgSDK.asmx?WSDL -Credential $mycredswrite-host "************************** list ask **************"foreach ($element in $table) { $Nomtache = $element.TASK_NAME $next = $element.NEXT_START $taskid = $element.LD_TASK_IDN $Retentionday = 30 If($Nomtache -like "*EN-BE*"){ $Retentionday = 2 } If(($Nomtache -notlike "*PORTAL*") -and ($Nomtache -notlike "*Download patch content*")){ write-host $Nomtache if ($next -like "*/*") { $next = [DateTime]$next $ts = New-TimeSpan -Start $next -End $currentdate $nbday = $ts.Days write-host "Nombredejours=$nbday" if($nbday -gt $Retentionday) { Write-host "delete=$taskid" -ForegroundColor Yellow $ldWS.DeleteTask($taskid) } } Else { #Write-host "delete=$taskid" -ForegroundColor Yellow } write-host $next write-host " " }} |
