Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

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

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

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:

SELECT SCC_SourceControlProfiles.Name AS [Source Control Profile], TM_TestPlanNodes.Name AS [Test Container Name],
SCC_Projects.ProjectName AS [Project Name]
FROM TM_TestContainers INNER JOIN
SCC_SourceControlProfiles ON TM_TestContainers.SourceControlID_pk_fk = SCC_SourceControlProfiles.SourceControlID_pk INNER JOIN
TM_TestPlanNodes ON TM_TestContainers.TestContainerID_pk_fk = TM_TestPlanNodes.NodeID_pk INNER JOIN
SCC_Projects ON TM_TestContainers.ProjectID_fk = SCC_Projects.ProjectID_pk
WHERE (SCC_SourceControlProfiles.Name LIKE "%")

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.



Old KB# 25139

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:53
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.