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

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
Anonymous
Related Discussions
Recommended