Overview We can delete files older than X days. We can create a scheduled task to run the PowerShell script on a schedule. List Files To Delete
|
1 |
Get-ChildItem -Path "C:\SomePath\Folder" -Recurse -Force | Where-Object { !$_.PSIsContainer -and $_.Lastwritetime -lt (Get-Date).AddDays(-8) } |
This code uses the Get-ChildItem and Where-Object cmdlets to search for all…
The Code
|
1 2 3 4 5 6 7 8 9 10 11 |
try { Invoke-Sqlcmd -ServerInstance ServerName -Database DatabaseName -Query 'EXEC sp_StoredProcedureName' |select -ExpandProperty XML_F52E2B61-18A1-11d1-B105-00805F49916B| Out-File -FilePath E:\FilePath\Filename_$(get-date -f yyyyMMdd).xml (Get-Content E:\FilePath\Filename_$(get-date -f yyyyMMdd).xml -Raw).Replace("`r`n","") | Set-Content E:\FilePath\Filename_$(get-date -f yyyyMMdd).xml -Force } catch { Add-Content -Path "E:\FilePath\ErrorLog\PSErrorLog.txt" -Value (Write-Output $(Get-Date) $_) -Force } |
The Analysis This code is written in PowerShell to execute a stored procedure on a Microsoft SQL Server and save the results to an XML file. The first line of code invokes the Invoke-Sqlcmd cmdlet, which allows…
The Invoke-Sqlcmd module is a PowerShell module that will allow you to execute T-SQL statements. In order to install the Invoke-Sqlcmd module, you will need to open PowerShell. Before installing the module, you need to set the execution policy to…