You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Table to find instance name/Environment Name

Hi Team,

Could you please share a table or SQL to find the instance name, when values would be DEV1, DEV2, or PROD.

I have already checked the ASK_DEPLOYED_DOMAINS table and tweaked query to extract the instance name using EXTERNAL_VIRTUAL_HOST column.

But issues occur when the URL structure is different, hence unable to extract the required instance name to be displayed in the report output.

Regards,

Swapnil

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!