How can I generate an excel report displaying the automation tests run in ALM

  • Questions
  • How can I generate an excel report displaying the automation tests run in ALM
Question ID: 106965
0
0

I need to generate a report of tests from ALM that were run automatically from UFT. Is there a flag anywhere that marks a test run as an automated run so I can report on this? Is there any way to do this?

Marked as spam
Posted by (Questions: 217, Answers: 21)
Asked on July 15, 2016 9:04 pm
5 views
Answers (1)
0
Private answer

The TS_TYPE column in the TEST table displays the type. The following query will generate an excel report in the Analysis View module. You may need to edit the query to meet your specific needs depending on the test type. To create the excel report, you will need to make sure that the ENABLE_CREATE_LEGACY_EXCEL_REPORT parameter has been added in Site Admin. 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
TS_NAME,
TS_SUBJECT,
TS_STATUS,
TS_RESPONSIBLE,
TS_CREATION_DATE,
TS_DESCRIPTION,
TS_TYPE,
TS_EXEC_STATUS
FROM TEST
WHERE TS_TYPE = 'QUICKTEST_TEST'

Marked as spam
Posted by (Questions: 2, Answers: 278)
Answered on July 15, 2016 9:06 pm