Related Tips & Info

How to generate reports of manual and SilkTest automated Test Definitions from an SCTM project?

MigrationDeletedUser
0 Likes

Problem:

How to generate reports of manual and SilkTest automated Test Definitions from an SCTM project?

Resolution:

The following query returns theManual Test Definitions in a SilkCentral Test Manager project. Pleasecopy the query into a report data query by selecting "Advanced Query"in the report view.


SELECT DISTINCT
SCC_Projects.ProjectName AS [Project Name], TM_TestPlanNodes_1.Name AS [Test Container Name],

TM_TestPlanNodes.Name AS [Test Definition Name]
FROM TM_PlanTreePaths INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_1 INNER JOIN
TM_TestContainers ON TM_TestPlanNodes_1.NodeID_pk = TM_TestContainers.TestContainerID_pk_fk ON
TM_PlanTreePaths.ParentNodeID_pk_fk = TM_TestContainers.TestContainerID_pk_fk INNER JOIN
SCC_Projects INNER JOIN
LQM_Tests INNER JOIN
TM_TestDefinitions ON LQM_Tests.TestID_pk = TM_TestDefinitions.TestPlanNodeID_pk_fk INNER JOIN
TM_TestPlanNodes ON TM_TestDefinitions.TestPlanNodeID_pk_fk = TM_TestPlanNodes.NodeID_pk ON
SCC_Projects.ProjectID_pk = LQM_Tests.ProjectID_fk ON TM_PlanTreePaths.NodeID_pk_fk = TM_TestPlanNodes.ParentNodeID_fk INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_2 ON TM_TestDefinitions.TestPlanNodeID_pk_fk = TM_TestPlanNodes_2.NodeID_pk INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_3 ON TM_PlanTreePaths.NodeID_pk_fk = TM_TestPlanNodes_3.NodeID_pk INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_4 ON TM_TestDefinitions.TestPlanNodeID_pk_fk = TM_TestPlanNodes_4.NodeID_pk INNER JOIN
TM_PlanTreePaths AS TM_PlanTreePaths_1 ON TM_TestPlanNodes_4.ParentNodeID_fk = TM_PlanTreePaths_1.NodeID_pk_fk AND
TM_PlanTreePaths.ParentNodeID_pk_fk = TM_PlanTreePaths_1.ParentNodeID_pk_fk INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_5 ON TM_PlanTreePaths_1.NodeID_pk_fk = TM_TestPlanNodes_5.NodeID_pk INNER JOIN
TM_ManualTestDefinitions ON TM_TestPlanNodes_2.NodeID_pk = TM_ManualTestDefinitions.TestDefID_pk_fk
WHERE (SCC_Projects.ProjectName = "TestProject")


The following query returns the SilkTest Test Definitions (automated) in aSilkCentral Test Manager project. Please copy the query into a reportdata query by selecting "Advanced Query" in the report view.


SELECT DISTINCT
SCC_Projects.ProjectName AS [Project Name], TM_TestPlanNodes_1.Name AS [Test Container Name],

TM_TestPlanNodes.Name AS [Test Definition Name]
FROM TM_PlanTreePaths INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_1 INNER JOIN
TM_TestContainers ON TM_TestPlanNodes_1.NodeID_pk = TM_TestContainers.TestContainerID_pk_fk ON
TM_PlanTreePaths.ParentNodeID_pk_fk = TM_TestContainers.TestContainerID_pk_fk INNER JOIN
SCC_Projects INNER JOIN
LQM_Tests INNER JOIN
TM_TestDefinitions ON LQM_Tests.TestID_pk = TM_TestDefinitions.TestPlanNodeID_pk_fk INNER JOIN
TM_TestPlanNodes ON TM_TestDefinitions.TestPlanNodeID_pk_fk = TM_TestPlanNodes.NodeID_pk ON
SCC_Projects.ProjectID_pk = LQM_Tests.ProjectID_fk ON TM_PlanTreePaths.NodeID_pk_fk = TM_TestPlanNodes.ParentNodeID_fk INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_2 ON TM_TestDefinitions.TestPlanNodeID_pk_fk = TM_TestPlanNodes_2.NodeID_pk INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_3 ON TM_PlanTreePaths.NodeID_pk_fk = TM_TestPlanNodes_3.NodeID_pk INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_4 ON TM_TestDefinitions.TestPlanNodeID_pk_fk = TM_TestPlanNodes_4.NodeID_pk INNER JOIN
TM_PlanTreePaths AS TM_PlanTreePaths_1 ON TM_TestPlanNodes_4.ParentNodeID_fk = TM_PlanTreePaths_1.NodeID_pk_fk AND
TM_PlanTreePaths.ParentNodeID_pk_fk = TM_PlanTreePaths_1.ParentNodeID_pk_fk INNER JOIN
TM_TestPlanNodes AS TM_TestPlanNodes_5 ON TM_PlanTreePaths_1.NodeID_pk_fk = TM_TestPlanNodes_5.NodeID_pk INNER JOIN
TM_SilkTestDefinitions ON TM_TestPlanNodes_2.NodeID_pk = TM_SilkTestDefinitions.TestDefID_pk_fk
WHERE (SCC_Projects.ProjectName = "TestProject")

Old KB# 25177
Comment List
Related
Recommended

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.