The following queries would do the same function than deleting the files logically from Filezilla, they will delete the record from the logical table and fill in the SRPF_GC_DETECTED_TIME in the physical table which is taken for reference for the deletion.
This is just a sample that may require more effort, involve your DBA for further assistance creating the desired query,
UPDATE TD.SMART_REPOSITORY_PHYSICAL_FILE SET SRPF_GC_DETECTED_TIME=GETDATE()
WHERE SRPF_ID in (select SRLF_PHYSICAL_ID FROM td.SMART_REPOSITORY_LOGICAL_FILE WHERE SRLF_NAME=’default.usp’)
DELETE FROM [default_123_db].[td].[SMART_REPOSITORY_LOGICAL_FILE] WHERE SRLF_NAME=’default.usp’
Additionally, in this way you can specify the name of the attachment being useful to delete specific files as ‘VuserLog.zip’.
After the queries are applied run the Promote Repository cleanup.