ReleaseDeployment
Overview
ReleaseDeployment dataset contains the metadata for the MSAI Data Platform deployment.
Basic Information
Freshness: Daily Refresh
Upstream Data Source: 1ES CloudMine Data
Data Retention: No Expiration
Data Content: Information related to Deployment.
Columns
| Column Name | Data Type | Description | Sample Value | IsNullable |
|---|---|---|---|---|
| ID | int | Auto-increment field | 1111 | False |
| DeploymentMethod | varchar(100) | The deployment infrastructure that supports the deployment service | AzDevOps | False |
| ReleaseEnvironmentName | varchar(100) | The deployment envrionment | PROD | True |
| ReleaseDefinitionName | varchar(100) | The deployment pipeline name | msai-datapipeline | True |
| ReleaseId | int | The identifier of the deployment release candidate | 887 | True |
| DeploymentStatus | varchar(100) | The deployment result status | succeeded | False |
| RequestedByUniqueName | varchar(100) | The requestor who trigger the deployment | wanqi@microsoft.com | True |
| CodeCheckInOn | datetime | The datetime of the code change completed | 2022-02-10 19:45:59.373 | False |
| ArtifactGenerateOn | datetime | The datetime of the release artifacts generation completes | 2022-02-10 20:03:44.677 | False |
| DeploymentReadyOn | datetime | The datetime of the deployment candidate is ready | 2022-02-10 20:04:37.303 | False |
| RequestedOn | datetime | The datetime of the deployment triggered | 2022-02-11 07:03:22.227 | False |
| StartedOn | datetime | The datetime of the deployment execution starts | 2022-02-11 07:04:12.120 | True |
| CompletedOn | datetime | The datetime of the deployment completed | 2022-02-11 07:11:39.990 | True |
| DeploymentOverallDuration | int | The minutes of the deployment from triggering to completion | 8 | True |
| DeploymentQueueDuration | int | The minutes of the deployment is queued for starting | 1 | True |
| DeploymentDuration | int | The minutes of the deployment execution | 7 | True |
Usage
Sample Scripts
Find specific data according to criteria of the ReleaseDeployment,as input or output
SELECT ID
,DeploymentMethod
,ReleaseEnvironmentName
,ReleaseDefinitionName
,ReleaseId
,DeploymentStatus
,RequestedByUniqueName
,CodeCheckInOn
,ArtifactGenerateOn
,DeploymentReadyOn
,RequestedOn
,StartedOn
,CompletedOn
,DeploymentOverallDuration
,DeploymentQueueDuration
,DeploymentDuration
FROM [dbo].[ReleaseDeployment]
where ReleaseEnvironmentName = 'PROD'
and DeploymentMethod = 'Phoenix'
and RequestedByUniqueName = 'Congwen.Min@microsoft.com'
Sample Data
| ID | DeploymentMethod | ReleaseEnvironmentName | ReleaseDefinitionName | ReleaseId | DeploymentStatus | RequestedByUniqueName | CodeCheckInOn | ArtifactGenerateOn | DeploymentReadyOn | RequestedOn | StartedOn | CompletedOn | DeploymentOverallDuration | DeploymentQueueDuration | DeploymentDuration |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1228 | AzDevOps | PROD | msai-datapipeline | 724 | succeeded | pingzhongwei@microsoft.com | 2022-01-28 10:19:14.547 | 2022-01-28 10:33:03.953 | 2022-01-28 10:33:16.873 | 2022-01-28 10:45:11.670 | 2022-01-28 10:53:37.647 | 2022-01-28 11:00:30.350 | 15 | 8 | 7 |
| 1241 | AzDevOps | PROD | msai-datapipeline | 550 | succeeded | pingzhongwei@microsoft.com | 2021-12-23 07:22:40.327 | 2021-12-23 07:40:49.190 | 2021-12-23 07:40:58.570 | 2021-12-23 08:28:28.807 | 2021-12-23 08:28:58.307 | 2021-12-23 08:31:10.997 | 3 | 0 | 3 |
| 1243 | AzDevOps | PROD | msai-datapipeline | 550 | succeeded | pingzhongwei@microsoft.com | 2021-12-23 07:22:40.327 | 2021-12-23 07:40:49.190 | 2021-12-23 07:40:58.570 | 2021-12-23 07:51:40.707 | 2021-12-23 07:52:51.643 | 2021-12-23 07:55:28.540 | 4 | 1 | 3 |