select substr(CONNURL,regexp_instr(CONNURL,':',1,2,2),4),CONNURL from PSGATEWAY
if same as report server:
select substr(URL,regexp_instr(URL,':',1,2,2),4) from PS_CDM_DIST_NODE
useful if single sign-on on same server to multiple dbs, just change url on address bar.
