This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.
script to delete old files in server folders after a week
Hi
We have an FTP server with users with multiple folders. The requirement is that users delete the old files after a week,
I am looking at doing this automatically,
Does anyone know if this can be done is power shell or a batch script, that will go to a folder or sub folders, look for files older than a week and delete them
Thanks
V
We have an FTP server with users with multiple folders. The requirement is that users delete the old files after a week,
I am looking at doing this automatically,
Does anyone know if this can be done is power shell or a batch script, that will go to a folder or sub folders, look for files older than a week and delete them
Thanks
V
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
save as cleanup.cmd or cleanup.bat
You need to modify the line 2 to specify the top level folder.
==========================
@echo off
set topLevel=d:\some\directory
cd /D %topLevel%
FOR /D %%a IN (*) DO (
forfiles /P "%topLevel%\%%a" /S /M *.* /D -7 /C "cmd /C del @PATH"
cd /D %topLevel%\%%a
for /f "delims=" %%i in ('dir /s /b /ad ^| sort /r') do rd "%%i">NUL
)
==========================
You need to modify the line 2 to specify the top level folder.
==========================
@echo off
set topLevel=d:\some\directory
cd /D %topLevel%
FOR /D %%a IN (*) DO (
forfiles /P "%topLevel%\%%a" /S /M *.* /D -7 /C "cmd /C del @PATH"
cd /D %topLevel%\%%a
for /f "delims=" %%i in ('dir /s /b /ad ^| sort /r') do rd "%%i">NUL
)
==========================
If you want Powershell here is another option.
Schedule this to run daily with a Scheduled Task
powershell.exe 'DeleteFTP.ps1'
get-childitem -path '\\ftpserver\Clients' -recurse | where {$_.lastwritetime -lt (get-date).adddays(-7) -and -not $_.psiscontainer} |% {remove-item $_.fullname -force}
Schedule this to run daily with a Scheduled Task
powershell.exe 'DeleteFTP.ps1'
Why not just use a small free utility called DELAGE for this, it's a great tool, that I use often.
http://www.horstmuc.de/wbat32.htm
http://www.horstmuc.de/win/delage.htm
~bp
http://www.horstmuc.de/wbat32.htm
http://www.horstmuc.de/win/delage.htm
~bp
if the directory folder names are different is there a select all command
set topLevel=d:\some\directory
e.g c:\ftp\ftp_users\jakeholla
where there could be a hundred different usernames, but I want to delete all files in each users directory without running the script for each user.
set topLevel=d:\some\directory
e.g c:\ftp\ftp_users\jakeholla
where there could be a hundred different usernames, but I want to delete all files in each users directory without running the script for each user.
The powershell script I supplied for you does not care about the folder structure, but the age of the file.
I am not sure if you need to be concerned with folders since you are looking for file ages.
I am not sure if you need to be concerned with folders since you are looking for file ages.
find LOCATION -not -mtime 6 -delete
deletes all the files which have not been modified in the past 7 days
if you are running windows, versions of the find command for windows are available in cygwin, in findutils (http://gnuwin32.sourceforge.net/packages/findutils.htm) and in various other places. the builtin find command in windows does not have such capabilities afaik
deletes all the files which have not been modified in the past 7 days
if you are running windows, versions of the find command for windows are available in cygwin, in findutils (http://gnuwin32.sourceforge.net/packages/findutils.htm) and in various other places. the builtin find command in windows does not have such capabilities afaik
Premium Content
You need an Expert Office subscription to comment.Start Free Trial