A folder contain ‘n’ number of files. In that, I want to delete only file names which starts with ‘Tcp’, that too which are older than 30 days and latest files should remain as it is. I have a script but its deleting all the tcp files inside the folder.
But need to delete only files, whose name starts with TCP, which are created 30 days back.
Can someone please help me on this?
There are a couple million examples of this. Have you tried anything? Have you tried to search?
It’d be better for you to bring some code that you’ve written and ask a specific question about it. We’re not set up to write complete solutions for you. If you’re having trouble just understanding the logic you’d use, it’s fine to ask that, too - folks can outline the logical steps they’d use. But, to echo the previous comment, this is something that’s been asked here hundreds of times - it might be worth a search of the forums to see what’s already been asked and answered.
Yes Rob.
I got couple of scripts, but it’s deleting all the files inside the folder.
script 1)
$limit = (Get-Date).AddMinutes(-1)
$path = "C:\Users\mpradeep\Downloads\sample nuget apps"
$include = “Tcp.*”
script 2)
$Now = Get-Date
$Minutes = “-1”
$TargetFolder = "C:\Users\mpradeep\Downloads\sample nuget apps"
$Extension = “Tcp.*”
$LastWrite = $Now.AddDays(-$Minutes)
$Files = Get-Childitem $TargetFolder -Include $Extension -Recurse | Where {$_.LastWriteTime -le “$LastWrite”}
foreach ($File in $Files)
{
if ($File -ne $NULL)
{
write-host “Deleting File $File” -ForegroundColor “DarkRed”
Remove-Item $File.FullName | out-null
}
else
{
Write-Host “No more files to delete!” -foregroundcolor “Green”
}
}
yeah don.
I searched and got couple of answer for above query, even i altered the script too but script didn’t worked as expected, its deleting all the files inside the folder.
Some minor changes and condition to be included on the script, am not getting that.
So thought to post it here.
As i am very new to PS, i am trying to learn the things.
Yes Rob.
I got couple of scripts, but it’s deleting all the files inside the folder.
script 1)
$limit = (Get-Date).AddMinutes(-1)
$path = "C:\Users\mpradeep\Downloads\sample nuget apps"
$include = “Tcp.*”
Get-ChildItem -Path $path -include $include | Where-Object {$_.CreationTime -lt $limit} | Remove-Item
—————————————————————
script 2)
$Now = Get-Date
$Minutes = “-1”
$TargetFolder = "C:\Users\mpradeep\Downloads\sample nuget apps"
$Extension = “Tcp.*”
$LastWrite = $Now.AddDays(-$Minutes)
$Files = Get-Childitem $TargetFolder -Include $Extension -Recurse | Where {$_.LastWriteTime -le “$LastWrite”}
foreach ($File in $Files)
{
if ($File -ne $NULL)
{
write-host “Deleting File $File” -ForegroundColor “DarkRed”
Remove-Item $File.FullName | out-null
}
else
{
Write-Host “No more files to delete!” -foregroundcolor “Green”
}
}
$limit = (Get-Date).AddMinutes(-1)
and
Where-Object {$_.CreationTime -lt $limit}
Means “everything more than a minute old”. Sure the comparison is ‘lt’ (less than) but in a date value comparison [less than one minute ago] means everything earlier than whatever one minute ago was.
That’s what you’re targeting and deleting here.
So you need to change your condition to match your requirements:
$limit = (Get-Date).AddDays(-30) $Name = "Tcp*" $Files = Get-Childitem $TargetFolder -Include $Name #... rest of the script
hey joel,
Thanks.
But i was trying in my local server instead of production, instead of testing for 30 days i was trying for minutes.
I was testing, which ever the files are created less than 1 minutes, it should not get deleted and older files should get deleted.
especially the file name starts from “tcp.*”. but here all the files are getting deleted.
I have tried, even though it didn’t worked.
Please help me out.
Get-ChildItem 'C:\Scripts\Test\tcp*' |
Where{$_.LastWriteTime -lt (Get-Date).AddDays(-30)} |
Remove-Item -Force -WhatIf
Results:
PS C:\Users\Rob> Get-ChildItem 'C:\Scripts\Test'
Directory: C:\Scripts\Test
Mode LastWriteTime Length Name
---- ------------- ------ ----
-a---- 5/31/2018 12:02 PM 0 blue.txt
-a---- 5/31/2018 12:02 PM 0 green.txt
-a---- 4/16/2018 12:12 PM 0 tcp123.txt
-a---- 4/16/2018 12:12 PM 0 tcp321.txt
PS C:\Users\Rob> Get-ChildItem 'C:\Scripts\Test\tcp*' |
Where{$_.LastWriteTime -lt (Get-Date).AddDays(-30)} |
Remove-Item -Force -WhatIf
What if: Performing the operation "Remove File" on target "C:\Scripts\Test\tcp123.txt".
What if: Performing the operation "Remove File" on target "C:\Scripts\Test\tcp321.txt".
PS C:\Users\Pra> Get-ChildItem 'C:\Scripts\Tcp'
Directory: C:\Scripts\Tcp
Mode LastWriteTime Length Name
---- ------------- ------ ----
-a---- 5/31/2018 08:00 PM 0 pradeep.txt
-a---- 5/31/2018 10:00 PM 0 ashwin.txt
-a---- 5/31/2018 00:54 AM 0 tcp.1.2a.3.txt
-a---- 5/30/2018 10:12 PM 0 tcp.3ndc.21.txt
-a---- 5/30/2018 10:11 PM 0 tcp.txt
-a---- 5/30/2018 01:10 PM 0 tcp.23.c21.txt
PS C:\Users\Pra> Get-ChildItem 'C:\Scripts\tcp.*' |
Where{$_.LastWriteTime -lt (Get-Date).AddDays(-1)} |
Remove-Item -Force
In the above sample files, only tcp.3ndc.21.txt and tcp.23.c21.txt should be deleted. But in my case, even tcp.txt is being deleted. Can you please guide me on this?
Try changing your filter:
Get-ChildItem 'C:\Scripts\Test\tcp.*.txt' |
Where{$_.LastWriteTime -lt (Get-Date).AddDays(-30)} |
Remove-Item -Force -WhatIf
Thanks Rob.
It Worked for me.
if i need any help, i get back to you.
Yes, there’s a powershell bug where “get-childitem -include” only works with -recurse or a wildcard in the path. It’s fixed in PS6.
I like doing date comparisons this way, with an implied casting of ‘30’ to [timespan]:
ls | where { (get-date) - $_.lastwritetime -gt '30' }
Maybe this is better.
$30days = New-TimeSpan -Days 30
ls | where { (get-date) - $_.lastwritetime -gt $30days }
hi rob,
How to run/execute a PS script on remote servers ??
i just used like UCN path of the script,
\server-name\d$\Program-Files\script.ps1
But it didn’t worked !
please help me,
Thanks in advance.
Thanks JS