Forum Discussion

wpenfold's avatar
wpenfold
Contributor
2 years ago
Solved

Is there a way I can delete a folder and all files and subfolders from a windows server?

When an employee leaves, their personal folder and any subfolders and files they have created needs to be deleted. I know I can delete an empty directory, but how can i find/delete all the files and ...
  • jcornelius's avatar
    jcornelius
    4 years ago

    @Damone
    do it all in SQL
    ie
    IF EXIST(Select id from table_x where id=@id)
    BEGIN
    UPDATE table_x set col1=@col1 where id=@id
    END
    ELSE
    BEGIN
    INSERT INTO into table_x (id,col1) values(@id,@col1)
    END

svatada's avatar
svatada
Former Employee
2 years ago
Copy LinkReport

 

The FileDelete snap can indeed be utilised to delete files or empty directories.

FYI - If the file is a symbolic link, only the symbolic link itself, not the final target of the link, will be deleted. Moreover, if the file is a directory, the FileDelete snap will delete it only when the directory is empty.

On some operating systems it may not be possible to remove a file/directory when it is open and in use by this Java virtual machine or other programs.