Problem:

How do I determine which Test Container(s) is linked to a Source Control Profile?

Resolution:

In a large SilkCentral Test Manager project, there may be multiple Test Containers that are linked to a particular Source Control Profile that is no longer used. There may come a time when the Source Control Profile becomes marked for deletion. When performing the delete process, you may receive the following error message:

To determine which Test Containers are still linked to the Source Control Profile, without searching through every Test Container, use the following:

An SQL query could be used against the SilkCentral Test Manager database - this could be seen with SQL Server Enterprise Manager or equivalent. The above SQL query searches through all Test Containers and retrieves their Project Name and the associated Source Control Profile. From this result, much of the work of searching through every Test Container is removed and the user can go directly to the correct Test Container.

To perform the above in SilkCentral Test Manager:

• Go to Reports View and create a new child report.
• In the "Create New Report" dialog, click the "Advanced Query" button at the bottom left.
• Copy and paste the above SQL statement into the "Report data query" text area.
  • Please change "" to the Source Control Profile name you wish to search.

• Click "Check SQL" button to verify SQL statement.
• Click "Finish" button.
• With the new report selected, go to the "Data" tab and view the results.
  • You may need to click the "Update" button to retrieve query results.