Is there a TDV systems table that I can query to view the operations in my Deployment Manager plan?
Article ID: KB0082178
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | v 7.0.0 and higher |
Description
You can run the following query in ScratchPad to get a list of all the deployment manager plans:
select * from /services/databases/system/deployment/SYS_DEPLOYMENT_PLANS;
The query will display one row for every plan. Click on the row for your plan, and then view the DEFINITION column to view the operations. Below is a sample row for a plan named FirstDeploymentPlan:
DEPLOYMENT_PLAN_ID: 10160152
DEPLOYMENT_PLAN_NAME: FirstDeploymentPlan
TARGET_SITE_NAME: 172.21.246.144_9430
SOURCE_SITE_NAME: 172.21.246.144_9400
DEFINITION:
{"targetLocation":null, "operations":[{"principalSet":"FirstPrincipalBundle", "targetOperation":"ADD"}]}
ANNOTATION:
STATUS: [NULL]
OWNER: composite/admin
CREATE_TIME: 1521745214684
MODIFY_TIME: 1521745316618
MODIFY_USER: composite/admin
Example
select * from /services/databases/system/deployment/SYS_DEPLOYMENT_PLANS;
The query will display one row for every plan. Click on the row for your plan, and then view the DEFINITION column to view the operations. Below is a sample row for a plan named FirstDeploymentPlan:
DEPLOYMENT_PLAN_ID: 10160152
DEPLOYMENT_PLAN_NAME: FirstDeploymentPlan
TARGET_SITE_NAME: 172.21.246.144_9430
SOURCE_SITE_NAME: 172.21.246.144_9400
DEFINITION:
{"targetLocation":null, "operations":[{"principalSet":"FirstPrincipalBundle", "targetOperation":"ADD"}]}
ANNOTATION:
STATUS: [NULL]
OWNER: composite/admin
CREATE_TIME: 1521745214684
MODIFY_TIME: 1521745316618
MODIFY_USER: composite/admin
Example
Issue/Introduction
Is there a TDV systems table that I can query to view the operations in my Deployment Manager plan?
Feedback
Yes
No
Powered by
