These queries extract data from the Stewardship Tier and send it to the Knowledge Platform after the site has been added.
-- 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