rem get_oas_conf
rem V 1.2.1
rem by meo@bogliolo.name

column siteto format a5
column siteid format a5
column siten format a34
column succ format a70
column lsnrto format a34
column lslog format a70
column fail format a70
column home format a70
column ck format a5
column lgout format a70
column cookp format a5
column enc format a5
column sub format a20
column dn format a20
column url format a20
column mpre format a5
column mpos format a5
column comp format a40
column id format a16
column version format a16
column loginurl format a60
set pages 2000
set linesize 80

spool get_conf_oas

select
 substr(SITE_TOKEN,1,5) siteto,
 substr(SITE_ID,1,5) siteid,
 substr(SITE_NAME,1,34) siten,
 substr(ENCRYPTION_KEY,1,5) enc,
 substr(ENCRYPTION_MASK_PRE,1,5) mpre,
 substr(URLCOOKIE_PARAM,1,5) cookp,
 substr(ENCRYPTION_MASK_POST,1,5) mpos,
 substr(SUCCESS_URL,1,70) succ,
 substr(FAILURE_URL,1,70) fail,
 substr(HOME_URL,1,70) home,
 substr(LOGOUT_URL,1,70) lgout
from orasso.WWSSO_PAPP_CONFIGURATION_INFO$;
rem substr(URLCOOKIE_VERSION,1,5) ,
rem substr(URLCOOKIE_PARAM,1,5) ,

select
 substr(SITE_TOKEN,1,5) siteto,
 substr(SITE_ID,1,5) siteid,
 substr(LSNR_TOKEN,1,34) lsnrto,
 substr(ENCRYPTION_KEY,1,5) enc,
 substr(ENCRYPTION_MASK_PRE,1,5) mpre,
 substr(ENCRYPTION_MASK_POST,1,5) mpos,
 substr(URL_COOKIE_IP_CHECK,1,5) ck,
 substr(LS_LOGIN_URL,1,70) lslog
from orasso.WWSEC_ENABLER_CONFIG_INFO$;
rem substr(URLCOOKIE_VERSION,1,5),
rem substr(URL_COOKIE_IP_CHECK,1,5)

select
 substr(SITE_TOKEN,1,5) siteto,
 substr(SITE_ID,1,5) siteid,
 substr(LSNR_TOKEN,1,34) lsnrto,
 substr(ENCRYPTION_KEY,1,5) enc,
 substr(ENCRYPTION_MASK_PRE,1,5) mpre,
 substr(ENCRYPTION_MASK_POST,1,5) mpos,
 substr(URL_COOKIE_IP_CHECK,1,5) ck,
 substr(LS_LOGIN_URL,1,70) lslog
from portal.WWSEC_ENABLER_CONFIG_INFO$;
rem substr(URLCOOKIE_VERSION,1,5) ,
rem substr(URL_COOKIE_IP_CHECK,1,5)

select
 SUBSCRIBER_ID,
 substr(LOGIN_URL,1,60) loginurl
from orasso.WWSSO_LS_CONFIGURATION_INFO_T;

select
 SUBSCRIBER_ID,
 substr(SUBSCRIBER_NAME,1,20) sub,
 substr(DN,1,20) dn,
 substr(SUBSCRIBER_URL_PATH,1,20) url
from portal.WWSUB_MODEL$;

select
 component_name comp,
 id,
 version
from ias_versions;

spool off

rem portal.wwsec_group$
rem portal.wwsec_person$
rem portal.update wwv_text