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
0