Sai76

Commodore
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2021-01-12
14:09
66 views
Is there a way we can download the size of the attachment from test scripts in Test lab.
There is a requirement from business that they wanted to download the attachment size from Test strict of the test set.
Is there a way we can fetch the sizes of each attachment of test scripts from the test lab.
1 Reply
thanhphan

Micro Focus Frequent Contributor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
2021-01-13
20:23
Attachments size information are stored in the SMART_REPOSITORY_LOGICAL_FILE table. You can determine the size of attachments in Test Lab by running a query similar to the one below:
SELECT CR_REFERENCE, CR_REF_ID,SRLF_SIZE FROM CROS_REF
left outer join SMART_REPOSITORY_LOGICAL_FILE ON SRLF_NAME=CR_REFERENCE
where cr_entity in ( 'STEP','TESTCYCL','RUN',)