Problem:

How can I export my SilkCentral Test Definitions into an Excel spreadsheet?

Resolution:

It is not possible to directly export Test Definitions to an Excel spreadsheet from SilkCentral TestManager but there are a number of ways that you can access and save the information. The following SQL query will return all Test Definitions for the current project:

SELECT td.TestName AS "Test Definition Name", td.TestDescription AS "Test Definition Description" FROM TM_V_TestDefinitions td WHERE td.ProjectID=${$PROJECTID}

To return all Test Definitions for all projects simply omit the "WHERE td.ProjectID=${$PROJECTID}" statement.

If you run this query as a custom report within SilkCentral TestManager it can be displayed as an HTML page or as a PDF output.

To get this information into an Excel spreadsheet you will need to run the SQL query from SilkTest using a DB_Connect procedure and process the returned information into a csv file. That csv file can then be manually imported into an Excel spreadsheet.