ADOP scripts

======
clear columns
set pagesize 999

column node_name heading "Node Name" format a8
column support_cp heading "CP" format a3
column support_forms heading "Frm" format a3
column support_web heading "Web" format a3
column support_admin heading "Adm" format a3
column support_db heading "DB" format a3
column host heading "Host" format a8
column domain heading "Domain" format a15
column virtual_ip Heading "Virtual Name" format a8
column server_address Heading "IP Address" format a16

Select node_name, support_cp, support_forms, support_web, support_admin, support_db, host, domain, virtual_ip, server_address
from fnd_nodes
where node_name not in ('AUTHENTICATION', 'METADATA', 'TEMPLATE');
===============================================
set pagesize 999
clear columns

column name heading "Name" format A17
column DB heading "DB" format A2
column Admin heading "Adm" format A3
column Web heading "Web" format A3
column Forms heading "Frm" format A3
column Conc heading "Cnc" format A3
column FDev heading "FD" format A3
column CDev heading "CD" format A3
column WDev heading "WD" format A3
column adAdmin heading "adAd" format A4
column aDWeb heading "adW" format A3
column adForms heading "adF" format A3
column adConc heading "adC" format A3
column adFDev heading "adFD" format A4
column adCDev heading "adCD" format A4
column adWDev heading "adWD" format A4

SELECT name
, extractValue(xmltype(text),'//*[@oa_var=''s_isDB'']') AS DB
, extractValue(xmltype(text),'//*[@oa_var=''s_isAdmin'']') AS Admin
, extractValue(xmltype(text),'//*[@oa_var=''s_isWeb'']') AS Web
, extractValue(xmltype(text),'//*[@oa_var=''s_isForms'']') AS Forms
, extractValue(xmltype(text),'//*[@oa_var=''s_isConc'']') AS Conc
, extractValue(xmltype(text),'//*[@oa_var=''s_isFormsDev'']') AS FDev
, extractValue(xmltype(text),'//*[@oa_var=''s_isConcDev'']') AS CDev
, extractValue(xmltype(text),'//*[@oa_var=''s_isWebDev'']') AS WDev
, extractValue(xmltype(text),'//*[@oa_var=''s_isAdAdmin'']') AS adAdmin
, extractValue(xmltype(text),'//*[@oa_var=''s_isAdWeb'']') AS adWeb
, extractValue(xmltype(text),'//*[@oa_var=''s_isAdForms'']') AS adForms
, extractValue(xmltype(text),'//*[@oa_var=''s_isAdConc'']') AS adConc
, extractValue(xmltype(text),'//*[@oa_var=''s_isAdFormsDev'']') AS adFDev
, extractValue(xmltype(text),'//*[@oa_var=''s_isAdConcDev'']') AS adCDev
, extractValue(xmltype(text),'//*[@oa_var=''s_isAdWebDev'']') AS adWDev
FROM fnd_oam_context_files
WHERE name NOT IN('TEMPLATE','METADATA') AND status! ='H'
and ctx_type = 'A';
===========================
select ADOP_SESSION_ID,BUG_NUMBER,ADPATCH_OPTIONS, CLONE_STATUS,STATUS,NODE_NAME
from AD_ADOP_SESSION_PATCHES
order by ADOP_SESSION_ID;
=========================
select ADOP_SESSION_ID, EDITION_NAME, NODE_TYPE, NODE_NAME, APPLTOP_ID, PREPARE_STATUS,
APPLY_STATUS, CUTOVER_STATUS, CLEANUP_STATUS, ABORT_STATUS, STATUS
from AD_ADOP_SESSIONS
order by ADOP_SESSION_ID;
================================