Show Deployments
Summary
Use SHOW DEPLOYMENTS to list a summary history of all DEPLOY operations made to or from the Connect environment. The DEPLOY command migrates all domain objects from one Connect environment (source) to another (target) and is useful for code promotion activities.
Syntax
show deployments; |
Parameters
n/a
Details
The following table describes each column returned in the command’s result set. The information in the output will vary depending on if you have issued the command from the source or target environment.
|
Column Name
|
Data Type
|
Description
|
|---|---|---|
| id | string | Uniquely identifies each deployment row. |
| name | string | Literal: “Deployments for Connect service created at : “+ created_instant |
| description | string | n/a |
| deployment_type | string | Indicates system/environment perspective of the deploy history row:
‘0’ – source system perspective ‘1’ – target system perspective |
| from_machine | string | Source machine name or label |
| to_machine | string | Target machine name or label |
| source_session | string | The session_id from the source system that initiated the DEPLOY. |
| invocation_id | string | n/a |
| pre_snapshot_id | string | DEPLOY automatically snapshots the current state of the domain objects in the target environment prior to applying the source’s snapshot domain objects. |
| post_snapshot_id | string | DEPLOY automatically snapshots the state of the domain objects on the target environment after the deployment has completed. |
| created_by | string | The Connect user who initiated the deploy from the source environment. |
| created_instant | instant | The UTC instant when DEPLOY started. |
| modified_by | string | n/a |
| modified_instant | instant | n/a |
Examples
Source system view for a deployment:
select id, name, deployment_type, from_machine, to_machine, source_session, pre_snapshot_id, post_snapshot_id
from (show deployments)
where source_session = ‘2c90941956a6808101570ff4c0852c53’
order by created_instant;
Target system view for the same deployment:
select id, name, deployment_type, from_machine, to_machine, source_session, pre_snapshot_id, post_snapshot_id
from (show deployments)
where source_session = ‘2c90941956a6808101570ff4c0852c53’
order by created_instant;
Related Commands