Cloud instance name

Summary

Query to fetch cloud instance name

Content

Table: ASK_DEPLOYED_DOMAINS

Schema: FUSION_SETUP

The field EXTERNAL_VIRTUAL_HOST stores the external link

Condition: DEPLOYED_DOMAIN_NAME='FADomain' (Check the domain name and replace the value)

select         DEPLOYED_DOMAIN_ID,

 DEPLOYED_DOMAIN_NAME,

 EM_HOME_URL,

 INTERNAL_VIRTUAL_HOST,

 INTERNAL_VIRTUAL_PORT,

 EXTERNAL_VIRTUAL_HOST,

 EXTERNAL_VIRTUAL_PORT,

 JMX_PORT,

 NODE_MANAGER_PORT,

 ADMIN_HOST,

 ADMIN_PORT,

 LOGICAL_DOMAIN_ID,

 NODE_MANAGER_PROTOCOL,

 ADMIN_SERVER_NAME,

 APPLICATION_CLOUD_ID,

 INTERNAL_SERVER_PROTOCOL,

 EXTERNAL_SERVER_PROTOCOL,

 ADMIN_SERVER_PROTOCOL,

 OBJECT_VERSION_NUMBER,

 ENTERPRISE_ID,

 CREATION_DATE,

 CREATED_BY,

 LAST_UPDATED_BY,