How to find corrupted/damaged attachments in a ALM project?

Question ID: 109647
0
0
Irrespective of the ALM entity ( Run,Run Step, Bug, Test, Design Step, Step etc ) to which attachments are attached to, how can we find which all attachments got damaged or corrupted in a ALM project and to which entity they are linked to?

one option i tried is  finding out attachments that have 0 KB size in ALM project using below query:

SELECT CR_ENTITY,CR_KEY_1,CR_REFERENCE,SRLF_LAST_MODIFIED,(SRLF_SIZE/1024) kb FROM CROS_REF
LEFT OUTER JOIN SMART_REPOSITORY_LOGICAL_FILE ON CR_REFERENCE = SRLF_NAME
LEFT OUTER JOIN SMART_REPOSITORY_PHYSICAL_FILE ON SRLF_PHYSICAL_ID = SRPF_ID
WHERE SRLF_PARENT_PATH = '.\attach\' and (SRLF_SIZE/1024)= 0
ORDER BY kb

It gave correct result, when I navigate to the entities that are present in the result and when I tried to open attachment, they failed to open as they are 0 byte size.

Are there any other cases or factor’s like 0 KB size through which we can identify the damaged attachments in the project? Please advise.

Marked as spam
Posted by (Questions: 28, Answers: 21)
Asked on July 1, 2020 12:33 pm
8 views