How to create an Excel Spreadsheet report displaying the number of test scripts created or modified?

  • Questions
  • How to create an Excel Spreadsheet report displaying the number of test scripts created or modified?
Question ID: 106896
0
0

I am looking for assistance on how to create an excel spreadsheet report displaying the number of test scripts created or modified, along with the user that created or modified the test scripts in ALM.

Marked as spam
Posted by (Questions: 219, Answers: 23)
Asked on June 8, 2016 5:08 pm
2 views
Answers (1)
0
Private answer

First, you will need to make sure that the ENABLE_CREATE_LEGACY_EXCEL_REPORT parameter has been added in Site Admin if you are using a version of ALM 12.0 and newer. Next, you will need to access the Analysis View module. In the Analysis View module, click the drop down on the green plus button and select 'New Excel Report'. After you have named the excel report, enter the SQL query posted below into the Query1 text box and click 'Generate'. Select a save location for the excel report, click Save, and the excel report will open. If for some reason it doesn't open automatically, you can open from where it was saved. Hope this helps.

SELECT
''test''.''TS_TEST_ID'' AS ''id'',
''test''.''TS_NAME'' AS ''name'',
''test''.''TS_EXEC_STATUS'' AS ''exec_status'',
''test''.''TS_STATUS'' AS ''status'',
''test''.''TS_CREATION_DATE'' AS ''creation_time'',
''test''.''TS_DESCRIPTION'' AS ''description'',
''test''.''TS_RESPONSIBLE'' AS ''owner'',
''test''.''TS_STEPS'' AS ''steps'',
''test_folder''.''AL_DESCRIPTION'' AS ''test_folder'',
''test''.''TS_WORKING_MODE'' AS ''working_mode'',
''test''.''TS_VTS'' AS ''last_modified''
FROM
TEST ''test''
INNER JOIN ALL_LISTS ''test_folder'' ON ''test_folder''.''AL_ITEM_ID'' = ''test''.''TS_SUBJECT''

Marked as spam
Posted by (Questions: 2, Answers: 280)
Answered on June 8, 2016 5:12 pm