Delete specific files in ALM Repository

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s