Pages

Friday, December 2, 2011

Find out web server port number

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.