Metrics Extraction Queries

-- 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