--- title: "Metrics Extraction Queries" slug: "metrics-extraction-queries" updated: 2024-04-08T17:15:52Z published: 2024-04-08T17:15:52Z canonical: "skthelp.syniti.com/metrics-extraction-queries" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Metrics Extraction Queries These queries extract data from the Stewardship Tier and send it to the Knowledge Platform after the site has been added. ```sql -- SnapshotID SELECT TOP 1 [SnapShotID] FROM [Console].[dbo].[ztParam] -- Version SELECT [Version] FROM CranSoft.dbo.Webapp WHERE WebAppID = '0151A30B-2DD0-48AE-823D-D378E1FF5C05' -- Waves SELECT  WaveID as WaveID,  NAME as WaveName,  Description as WaveDescription FROM Console.dbo.ttWave -- Objects SELECT  ObjectID as ObjectID,  NAME as ObjectName FROM Console.dbo.ttObject -- ProcessAreas SELECT  ProcessAreaID as ProcessAreaID,  ProcessArea as ProcessArea,  Description as ProcessAreaDescription FROM Console.dbo.ttProcessArea -- PlanningGroups SELECT  PlanningGroupID as PlanningGroupID,  PlanningGroup as PlanningGroup FROM Console.dbo.ztPlanningGroup -- WaveMilestones SELECT  WaveMilestoneID,  WaveID,  Name,  CASE    WHEN (Console.dbo.ttwavemilestone.milestonedate <= GETDATE()) THEN CAST(concat((DATEPART(YEAR,        Console.dbo.ttwavemilestone.milestonedate)), RIGHT(concat('0', ((DATEPART(MONTH, Console.dbo.ttwavemilestone.milestonedate)))), 2),        RIGHT(concat('0', ((DATEPART(DAY,        Console.dbo.ttwavemilestone.milestonedate)))), 2)) AS INT)    ELSE console.dbo.ztParam.snapshotid  END AS milestonesnapshotid FROM Console.dbo.ttWaveMilestone CROSS JOIN Console.dbo.ztParam -- WavePlanningGroups SELECT  WavePlanningGroupID as WavePlanningGroupID,  WaveID as WaveID,  PlanningGroupID as PlanningGroupID FROM Console.dbo.ttWavePlanningGroup -- WaveProcessAreaObjects SELECT  ttWaveProcessAreaObject.WaveProcessAreaID as WaveProcessAreaID,  ttWaveProcessAreaObject.WaveProcessAreaObjectID as WaveProcessAreaObjectID,  ttWaveProcessAreaObject.ObjectID as ObjectID,  ttWaveProcessAreaObject.[Priority] as [Priority],  CranSoft.dbo.[User].Name AS ObjectOwner FROM Console.dbo.ttWaveProcessAreaObject  LEFT OUTER JOIN Cransoft.dbo.[User] ON ttWaveProcessAreaObject.Owner = CranSoft.dbo.[User].UserID -- WaveProcessAreaObjectTargets SELECT  WaveProcessAreaObjectTargetID as WaveProcessAreaObjectTargetID,  WaveProcessAreaObjectID as WaveProcessAreaObjectID,  Priority as TargetPriority,  NAME as TargetName,  Description as TargetDescription FROM Console.dbo.ttTarget WHERE type = N'Natural' -- Sources SELECT  SourceID as SourceID,  Source as SourceName FROM Console.dbo.ttSource -- MetricConfigs SELECT  MetricID as MetricID,  datasourceid as DataSourceID,  name as MetricName,  priority as Priority,  viewname as ViewName,  storedprocedurename as StoredProcedureName,  description as Description FROM Console.dbo.ztmetricconfig -- MetricIndicatorValues SELECT  MetricIndicatorID as MetricIndicatorID,  MetricID as MetricID,  indicatortext as IndicatorText,  indicatorvalue as IndicatorValue FROM Console.dbo.ztmetricindicatorvalue -- WaveProcessAreaObjectSnapshots for dsp versions >= 7.3 SELECT    console.dbo.ztParam.SnapShotID,    console.dbo.ttwaveprocessarea.waveid as WaveID,    Console.dbo.ttwaveprocessarea.waveprocessareaid as WaveProcessAreaID,    console.dbo.ttwaveprocessarea.processareaid as ProcessAreaID,    console.dbo.ttwaveprocessareaobject.waveprocessareaobjectid as WaveProcessAreaObjectID,    console.dbo.ttwaveprocessareaobject.objectid as ObjectID,    console.dbo.ttwaveprocessareaobject.waveplanninggroupid as WavePlanningGroupID,    console.dbo.ttwaveprocessareaobject.designstartdate as DesignStartDate,    console.dbo.ttwaveprocessareaobject.designcompletionduedate as DesignCompletionDueDate,    console.dbo.ttwaveprocessareaobject.mapstartdate as MapStartDate,    console.dbo.ttwaveprocessareaobject.mapcompletionduedate as MapCompletionDueDate,    console.dbo.ttwaveprocessareaobject.buildstartdate as BuildStartDate,    console.dbo.ttwaveprocessareaobject.buildcompletionduedate as BuildCompletionDueDate,    console.dbo.ttwaveprocessareaobject.Active,    (        SELECT        StatusDescription        FROM          console.dbo.ztObjectStatus        WHERE        (console.dbo.ttWaveProcessAreaObject.RelevancyRuleStatus = StatusValue)    ) AS RelevancyRuleStatus,    (        SELECT        StatusDescription        FROM            console.dbo.ztObjectStatus AS ztObjectStatus_2        WHERE        (console.dbo.ttWaveProcessAreaObject.PreLoadReportStatus = StatusValue)    ) AS PreLoadReportStatus,    (        SELECT        StatusDescription        FROM            console.dbo.ztObjectStatus AS ztObjectStatus_3        WHERE        (console.dbo.ttWaveProcessAreaObject.PostLoadReportStatus = StatusValue)    ) AS PostLoadReportStatus,    (        SELECT        StatusDescription        FROM            console.dbo.ztObjectStatus AS ztObjectStatus_4        WHERE        (console.dbo.ttWaveProcessAreaObject.LoadProgramStatus = StatusValue)    ) AS LoadProgramStatus,    (        SELECT        StatusDescription        FROM            console.dbo.ztObjectStatus AS ztObjectStatus_4        WHERE         (console.dbo.ttWaveProcessAreaObject.UnitTestStatus = StatusValue)    ) AS UnitTestStatus,    (        SELECT        ExecutionLevel        FROM            console.dbo.ztMigrationExecutionLevel AS ztMigrationExecutionLevel_1        WHERE        (console.dbo.ttWaveProcessAreaObject.ExecutionLevelID = ExecutionLevelID)    ) AS ExecutionLevel,    (        SELECT        ExecutionGroup        FROM            console.dbo.ztMigrationExecutionGroup AS ztMigrationExecutionGroup_1        WHERE        (console.dbo.ttWaveProcessAreaObject.ExecutionGroupID = ExecutionGroupID)    ) AS ExecutionGroup FROM console.dbo.ttwaveprocessareaobject INNER JOIN console.dbo.ttwaveprocessarea    ON console.dbo.ttwaveprocessareaobject.waveprocessareaid = Console.dbo.ttwaveprocessarea.waveprocessareaid INNER JOIN console.dbo.ttWave    ON console.dbo.ttWaveProcessArea.WaveID = console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE EXISTS (    SELECT waveprocessareaobjectid    FROM console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel    WHERE console.dbo.ttwaveprocessareaobject.waveprocessareaobjectid = console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel.waveprocessareaobjectid ) -- WaveProcessAreaObjectSnapshots for dsp versions < 7.3 SELECT    console.dbo.ztParam.SnapShotID,    console.dbo.ttwaveprocessarea.waveid as WaveID,    Console.dbo.ttwaveprocessarea.waveprocessareaid as WaveProcessAreaID,    console.dbo.ttwaveprocessarea.processareaid as ProcessAreaID,    console.dbo.ttwaveprocessareaobject.waveprocessareaobjectid as WaveProcessAreaObjectID,    console.dbo.ttwaveprocessareaobject.objectid as ObjectID,    console.dbo.ttwaveprocessareaobject.waveplanninggroupid as WavePlanningGroupID,    console.dbo.ttwaveprocessareaobject.designstartdate as DesignStartDate,    console.dbo.ttwaveprocessareaobject.designcompletionduedate as DesignCompletionDueDate,    console.dbo.ttwaveprocessareaobject.mapstartdate as MapStartDate,    console.dbo.ttwaveprocessareaobject.mapcompletionduedate as MapCompletionDueDate,    console.dbo.ttwaveprocessareaobject.buildstartdate as BuildStartDate,    console.dbo.ttwaveprocessareaobject.buildcompletionduedate as BuildCompletionDueDate,    console.dbo.ttwaveprocessareaobject.Active FROM console.dbo.ttwaveprocessareaobject INNER JOIN console.dbo.ttwaveprocessarea    ON console.dbo.ttwaveprocessareaobject.waveprocessareaid = Console.dbo.ttwaveprocessarea.waveprocessareaid INNER JOIN console.dbo.ttWave    ON console.dbo.ttWaveProcessArea.WaveID = console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE EXISTS (    SELECT waveprocessareaobjectid    FROM console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel    WHERE console.dbo.ttwaveprocessareaobject.waveprocessareaobjectid = console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel.waveprocessareaobjectid ) -- WaveProcessAreaObjectTargetSnapshots SELECT    console.dbo.ztParam.SnapShotID,    console.dbo.ttTarget.WaveProcessAreaObjectID as WaveProcessAreaObjectID,    console.dbo.ttTarget.WaveProcessAreaObjectTargetID as WaveProcessAreaObjectTargetID,    console.dbo.ttTarget.Status AS TargetStatus FROM console.dbo.ttTarget    INNER JOIN console.dbo.ttWaveProcessAreaObject        ON console.dbo.ttTarget.WaveProcessAreaObjectID = console.dbo.ttWaveProcessAreaObject.WaveProcessAreaObjectID    INNER JOIN console.dbo.ttWaveProcessArea        ON console.dbo.ttWaveProcessAreaObject.WaveProcessAreaID = console.dbo.ttWaveProcessArea.WaveProcessAreaID    INNER JOIN console.dbo.ttWave        ON console.dbo.ttWaveProcessArea.WaveID = console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE EXISTS (    SELECT waveprocessareaobjecttargetid    FROM console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel    WHERE console.dbo.ttTarget.WaveProcessAreaObjectTargetID  = console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel.waveprocessareaobjecttargetid ) -- WaveProcessAreaObjectTargetSourceSnapshots SELECT    console.dbo.ztParam.SnapShotID,    console.dbo.ttTarget.WaveProcessAreaObjectTargetID as WaveProcessAreaObjectTargetID,    console.dbo.ttTargetSource.WaveProcessAreaObjectTargetSourceID as WaveProcessAreaObjectTargetSourceID,    console.dbo.ttTargetSource.SourceDataSource AS SourceID,    console.dbo.ttWaveProcessAreaObject.Active FROM console.dbo.ttTarget    INNER JOIN console.dbo.ttTargetSource        ON console.dbo.ttTarget.WaveProcessAreaObjectTargetID = console.dbo.ttTargetSource.WaveProcessAreaObjectTargetID    INNER JOIN console.dbo.ttWaveProcessAreaObject        ON console.dbo.ttTarget.WaveProcessAreaObjectID = console.dbo.ttWaveProcessAreaObject.WaveProcessAreaObjectID    INNER JOIN console.dbo.ttWaveProcessArea        ON console.dbo.ttWaveProcessAreaObject.WaveProcessAreaID = console.dbo.ttWaveProcessArea.WaveProcessAreaID    INNER JOIN console.dbo.ttWave        ON console.dbo.ttWaveProcessArea.WaveID = console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE EXISTS (    SELECT waveprocessareaobjecttargetsourceid    FROM console.dbo.webWaveProcessAreaObjectTargetSource_ActiveTreeSel    WHERE ttTargetSource.waveprocessareaobjecttargetsourceid = console.dbo.webWaveProcessAreaObjectTargetSource_ActiveTreeSel.waveprocessareaobjecttargetsourceid ) -- WaveMilestoneSnapshots SELECT    console.dbo.ztParam.SnapShotID,    wavemilestoneid as WaveMilestoneID,    milestonedate as MilestoneDate,    waveloadcycleid as WaveLoadCycleID,    designcompleteupperthreshold,    designcompletelowerthreshold,    mappingcompleteupperthreshold,    mappingcompletelowerthreshold,    rulescompleteupperthreshold,    rulescompletelowerthreshold,    qualityupperthreshold,    qualitylowerthreshold,    CASE        WHEN            GetDate()-1 BETWEEN                ISNULL(                    lag(MilestoneDate) OVER (PARTITION BY Console.dbo.ttwavemilestone.WaveId ORDER BY Console.dbo.ttwavemilestone.WaveId, MilestoneDate),                GetDate()-1)            AND MilestoneDate            THEN 'Current'        WHEN MilestoneDate > getdate()            THEN 'Future'        ELSE 'Historical'    END AS MilestoneProgress FROM Console.dbo.ttwavemilestone    INNER JOIN Console.dbo.ttWave        ON console.dbo.ttwavemilestone.WaveID = Console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE (ISNULL(console.dbo.ttWave.EndDate, GETDATE()+1) >= GETDATE()) -- WaveMilestonePlanningGroupSnapshots SELECT    console.dbo.ztParam.SnapShotID,    wavemilestoneid as WaveMilestoneID,    waveplanninggroupid as WavePlanningGroupID FROM console.dbo.ttWaveMilestonePlanningGroup    INNER JOIN console.dbo.ttWave        ON console.dbo.ttWaveMilestonePlanningGroup.WaveID = console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE ISNULL(console.dbo.ttWave.EndDate, GETDATE()+1) >= GETDATE() -- DspInstanceSnapshotID SELECT console.dbo.ztParam.SnapShotID FROM console.dbo.ztParam -- WaveProcessAreaSnapshots SELECT    console.dbo.ztParam.SnapShotID,    console.dbo.ttWaveProcessArea.WaveID,    console.dbo.ttWaveProcessArea.WaveProcessAreaID,    console.dbo.ttWaveProcessArea.ProcessAreaID FROM console.dbo.ttWaveProcessArea    INNER JOIN        console.dbo.ttWave ON console.dbo.ttWaveProcessArea.WaveID = console.dbo.ttWave.WaveID    CROSS JOIN        console.dbo.ztParam WHERE EXISTS    (SELECT        WaveProcessAreaID    FROM            console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel    WHERE        (console.dbo.ttWaveProcessArea.WaveProcessAreaID = WaveProcessAreaID) ) -- WaveProcessAreaMetrics SELECT            console.dbo.ztParam.SnapShotID,    console.dbo.ttWaveProcessArea.WaveID,    console.dbo.ttWaveProcessArea.WaveProcessAreaID FROM console.dbo.ttWaveProcessArea    INNER JOIN        console.dbo.ttWave ON console.dbo.ttWaveProcessArea.WaveID = console.dbo.ttWave.WaveID    CROSS JOIN        console.dbo.ztParam WHERE EXISTS    (SELECT        WaveProcessAreaID    FROM            console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel    WHERE        (console.dbo.ttWaveProcessArea.WaveProcessAreaID = WaveProcessAreaID) ) -- WaveProcessAreaObjectMetrics SELECT    console.dbo.ztParam.SnapShotID,    console.dbo.ttwaveprocessarea.waveid as WaveID,    Console.dbo.ttwaveprocessarea.waveprocessareaid as WaveProcessAreaID,    console.dbo.ttwaveprocessarea.processareaid as ProcessAreaID,    console.dbo.ttwaveprocessareaobject.waveprocessareaobjectid as WaveProcessAreaObjectID FROM console.dbo.ttwaveprocessareaobject    INNER JOIN console.dbo.ttwaveprocessarea        ON console.dbo.ttwaveprocessareaobject.waveprocessareaid = Console.dbo.ttwaveprocessarea.waveprocessareaid    INNER JOIN console.dbo.ttWave        ON console.dbo.ttWaveProcessArea.WaveID = console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE EXISTS (    SELECT waveprocessareaobjectid    FROM console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel    WHERE console.dbo.ttwaveprocessareaobject.waveprocessareaobjectid = console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel.waveprocessareaobjectid ) -- WaveProcessAreaObjectTargetMetrics SELECT    console.dbo.ztParam.SnapShotID,    console.dbo.ttWave.WaveID as WaveID,    Console.dbo.ttWaveProcessArea.WaveProcessAreaID as WaveProcessAreaID,    console.dbo.ttTarget.WaveProcessAreaObjectID as WaveProcessAreaObjectID,    console.dbo.ttTarget.WaveProcessAreaObjectTargetID as WaveProcessAreaObjectTargetID FROM console.dbo.ttTarget    INNER JOIN console.dbo.ttWaveProcessAreaObject        ON console.dbo.ttTarget.WaveProcessAreaObjectID = console.dbo.ttWaveProcessAreaObject.WaveProcessAreaObjectID    INNER JOIN console.dbo.ttWaveProcessArea        ON console.dbo.ttWaveProcessAreaObject.WaveProcessAreaID = console.dbo.ttWaveProcessArea.WaveProcessAreaID    INNER JOIN console.dbo.ttWave        ON console.dbo.ttWaveProcessArea.WaveID = console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE EXISTS (    SELECT waveprocessareaobjecttargetid    FROM console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel    WHERE console.dbo.ttTarget.WaveProcessAreaObjectTargetID  = console.dbo.webWaveProcessAreaObjectTarget_ActiveTreeSel.waveprocessareaobjecttargetid ) -- WaveProcessAreaObjectTargetSourceMetrics SELECT    console.dbo.ztParam.SnapShotID,    console.dbo.ttWave.WaveID as WaveID,    Console.dbo.ttWaveProcessArea.WaveProcessAreaID as WaveProcessAreaID,    console.dbo.ttTarget.WaveProcessAreaObjectID as WaveProcessAreaObjectID,    console.dbo.ttTarget.WaveProcessAreaObjectTargetID as WaveProcessAreaObjectTargetID,    console.dbo.ttTargetSource.WaveProcessAreaObjectTargetSourceID as WaveProcessAreaObjectTargetSourceID,    console.dbo.ttTargetSource.SourceDataSource AS SourceID FROM console.dbo.ttTarget    INNER JOIN console.dbo.ttTargetSource        ON console.dbo.ttTarget.WaveProcessAreaObjectTargetID = console.dbo.ttTargetSource.WaveProcessAreaObjectTargetID    INNER JOIN console.dbo.ttWaveProcessAreaObject        ON console.dbo.ttTarget.WaveProcessAreaObjectID = console.dbo.ttWaveProcessAreaObject.WaveProcessAreaObjectID    INNER JOIN console.dbo.ttWaveProcessArea        ON console.dbo.ttWaveProcessAreaObject.WaveProcessAreaID = console.dbo.ttWaveProcessArea.WaveProcessAreaID    INNER JOIN console.dbo.ttWave        ON console.dbo.ttWaveProcessArea.WaveID = console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE EXISTS (    SELECT waveprocessareaobjecttargetsourceid    FROM console.dbo.webWaveProcessAreaObjectTargetSource_ActiveTreeSel    WHERE ttTargetSource.waveprocessareaobjecttargetsourceid = console.dbo.webWaveProcessAreaObjectTargetSource_ActiveTreeSel.waveprocessareaobjecttargetsourceid ) -- WaveMilestoneMetrics SELECT    console.dbo.ztParam.SnapShotID,    Console.dbo.ttWave.WaveID as WaveID,    Console.dbo.ttwavemilestone.wavemilestoneid as WaveMilestoneID FROM Console.dbo.ttwavemilestone    INNER JOIN Console.dbo.ttWave        ON console.dbo.ttwavemilestone.WaveID = Console.dbo.ttWave.WaveID, console.dbo.ztParam WHERE (ISNULL(console.dbo.ttWave.EndDate, GETDATE()+1) >= GETDATE()) -- WaveProcessAreas SELECT    WaveID as WaveID,    WaveProcessAreaID as WaveProcessAreaID,    ProcessAreaID as ProcessAreaID FROM Console.dbo.ttWaveProcessArea -- WaveLoadCycles only for dsp versions >= 7.3 SELECT            Console.dbo.ttWaveLoadCycle.WaveLoadCycleID,    Console.dbo.ttWaveLoadCycle.WaveID,    Console.dbo.ztLoadCycle.Name AS LoadCycle,    Console.dbo.ttWaveLoadCycle.Instance,    Console.dbo.ttWaveLoadCycle.PlannedStartDate,    Console.dbo.ttWaveLoadCycle.PlannedEndDate,    Console.dbo.ttWaveLoadCycle.ActualStartDate,    Console.dbo.ttWaveLoadCycle.ActualEndDate FROM Console.dbo.ttWaveLoadCycle    INNER JOIN Console.dbo.ztLoadCycle        ON Console.dbo.ttWaveLoadCycle.LoadCycleID = Console.dbo.ztLoadCycle.LoadCycleID -- WaveLoadCycleExecutionPlans only for dsp versions >= 7.3 SELECT            Console.dbo.ttWaveLoadCycleExecutionPlan.WaveLoadCycleExecutionPlanID,    Console.dbo.ttWaveLoadCycleExecutionPlan.WaveLoadCycleID,    Console.dbo.ttWaveLoadCycleExecutionPlan.WaveProcessAreaObjectExecutionTemplateID,    Console.dbo.ttWaveLoadCycleExecutionPlan.WaveProcessAreaObjectID,    Console.dbo.ttWaveLoadCycleExecutionPlan.WaveProcessAreaObjectTargetID,    Console.dbo.ztMigrationExecutionGroup.ExecutionGroup,    Console.dbo.ztMigrationExecutionLevel.ExecutionLevel,    Console.dbo.ttWaveExecutionGroupValue.Value AS WaveExecutionGroupValue,    Console.dbo.ttWaveLoadCycleExecutionPlan.Priority,    Console.dbo.ttWaveLoadCycleExecutionPlan.OpportunityView,    Console.dbo.ttWaveLoadCycleExecutionPlan.ErrorView,    Console.dbo.ttWaveLoadCycleExecutionPlan.WhereClause,    Cransoft.dbo.DataSource.[Database] AS DataSource,    Console.dbo.ttWaveLoadCycleExecutionPlan.OpportunityCount,    Console.dbo.ttWaveLoadCycleExecutionPlan.ErrorCount,    Console.dbo.ttWaveLoadCycleExecutionPlan.Started,    Console.dbo.ttWaveLoadCycleExecutionPlan.Completed,    Console.dbo.ttWaveLoadCycleExecutionPlan.ExecutionDate,    Console.dbo.ttWaveLoadCycleExecutionPlan.StartedDate,    Console.dbo.ttWaveLoadCycleExecutionPlan.PlannedDate,    Console.dbo.ttWaveLoadCycleExecutionPlan.LoadComments FROM Console.dbo.ttWaveExecutionGroupValue    INNER JOIN Console.dbo.ttWaveLoadCycleExecutionPlan        ON Console.dbo.ttWaveExecutionGroupValue.WaveExecutionGroupValueID = Console.dbo.ttWaveLoadCycleExecutionPlan.WaveExecutionGroupValueID    INNER JOIN Console.dbo.ztMigrationExecutionLevel        ON Console.dbo.ttWaveLoadCycleExecutionPlan.ExecutionLevelID = Console.dbo.ztMigrationExecutionLevel.ExecutionLevelID    INNER JOIN Console.dbo.ztMigrationExecutionGroup        ON Console.dbo.ttWaveLoadCycleExecutionPlan.ExecutionGroupID = Console.dbo.ztMigrationExecutionGroup.ExecutionGroupID    INNER JOIN Cransoft.dbo.DataSource        ON Console.dbo.ttWaveLoadCycleExecutionPlan.DataSourceID = Cransoft.dbo.DataSource.DataSourceID -- MetricLogs EXEC Console.dbo.apiRunMetricsIns ```