// Borland Code VOzohili // Date: 21 July 2009 // Get Execution Definition details of test run // Open SCTM database using SQL Enterprise Manager or equivalent // Run the SQL query below against SCTM database // In the 'WHERE' clause, please specify the execution definition id you wish to search SilkCentral Test Manager 2008 R2 SP1 -------------------------------------- SELECT SCC_Projects.ProjectName AS [Project Name], TM_TestPlanNodes.Name AS [Test Container Name], TM_ExecTreeNodes.NodeName AS [Execution Definition Name], TM_ExecutionDefinitions.ExecDefID_pk_fk AS [Execution Definition ID], TM_ExecDefinitionRuns.ProductName, TM_ExecDefinitionRuns.VersionName, TM_ExecDefinitionRuns.BuildName, TM_ExecDefinitionRuns.Keywords, CAST(TM_Executions.ExecutionTimestamp AS CHAR) AS [Execution Timestamp] FROM TM_Executions INNER JOIN TM_ExecDefinitionRuns ON TM_Executions.ExecutionID_pk = TM_ExecDefinitionRuns.ExecDefRunID_pk_fk INNER JOIN TM_ExecutionDefinitions ON TM_ExecDefinitionRuns.ExecDefID_fk = TM_ExecutionDefinitions.ExecDefID_pk_fk INNER JOIN TM_TestContainers ON TM_ExecutionDefinitions.TestContainerID_fk = TM_TestContainers.TestContainerID_pk_fk INNER JOIN TM_TestPlanNodes ON TM_TestContainers.TestContainerID_pk_fk = TM_TestPlanNodes.NodeID_pk INNER JOIN TM_ExecTreeNodes ON TM_ExecutionDefinitions.ExecDefID_pk_fk = TM_ExecTreeNodes.NodeID_pk INNER JOIN SCC_Projects ON TM_TestContainers.ProjectID_fk = SCC_Projects.ProjectID_pk AND TM_ExecTreeNodes.ProjectID_fk = SCC_Projects.ProjectID_pk WHERE (TM_ExecutionDefinitions.ExecDefID_pk_fk = '') SilkCentral Test Manager 2009 ------------------------------ SELECT SCC_Projects.ProjectName AS [Project Name], TM_TestPlanNodes.Name AS [Test Container Name], TM_ExecTreeNodes.NodeName AS [Execution Definition Name], TM_ExecutionDefinitions.ExecDefID_pk_fk AS [Execution Definition ID], TM_ExecDefinitionRuns.ProductName, TM_ExecDefinitionRuns.VersionName, TM_ExecDefinitionRuns.BuildName, TM_ExecDefinitionRuns.Keywords, CAST(TM_TestDefExecutions.ExecutionTimestamp AS CHAR) AS [Execution Timestamp] FROM TM_ExecDefinitionRuns INNER JOIN TM_ExecutionDefinitions ON TM_ExecDefinitionRuns.ExecDefID_fk = TM_ExecutionDefinitions.ExecDefID_pk_fk INNER JOIN TM_TestContainers ON TM_ExecutionDefinitions.TestContainerID_fk = TM_TestContainers.TestContainerID_pk_fk INNER JOIN TM_TestPlanNodes ON TM_TestContainers.TestContainerID_pk_fk = TM_TestPlanNodes.NodeID_pk INNER JOIN TM_ExecTreeNodes ON TM_ExecutionDefinitions.ExecDefID_pk_fk = TM_ExecTreeNodes.NodeID_pk INNER JOIN SCC_Projects ON TM_TestContainers.ProjectID_fk = SCC_Projects.ProjectID_pk AND TM_ExecTreeNodes.ProjectID_fk = SCC_Projects.ProjectID_pk INNER JOIN TM_TestDefExecutions ON TM_ExecDefinitionRuns.ExecDefRunID_pk_fk = TM_TestDefExecutions.ExecDefRunID_fk AND SCC_Projects.ProjectID_pk = TM_TestDefExecutions.ProjectID_fk WHERE (TM_ExecutionDefinitions.ExecDefID_pk_fk = '')