YES!
I knew you would like the last post!
So, remains a doubt. What about my Oracle Application park?
Be soft. I’m glad to help. At real, Dieison Santos and me. As I said in the last post, it was his problem theese days… 😛
Here is a query to list your Oracle Application Products (including Oracle SOA Suite, of course) from OEM.
Use wisely:
select distinct * from ( select (LBL_HOSTNAME) "Host", (CASE when LBL_PRODUCTNAME like 'WebLogic Server' then 'WebLogic Suite' when LBL_PRODUCTNAME like '%WebTier and Utilities%' then 'WebLogic Suite' when LBL_PRODUCTNAME like '%EM Platform (OMS)%' then 'WebLogic Suite' when LBL_PRODUCTNAME like '%Web Services Manager%' then 'Diagnostics Pack for Internet Application Server' when LBL_PRODUCTNAME like '%Application Server 10g%' then 'Internet Application Server Enterprise Edition' when LBL_PRODUCTNAME like '%Application Server Infrastructure 10g%' then 'Oracle Enterprise Single Sign-On Suite' when LBL_PRODUCTNAME like '%Business Intelligence%' then 'Oracle Business Intelligence Suite Enterprise Edition Plus' when LBL_PRODUCTNAME like '%Oracle SOA Suite%' then 'SOA Suite for Oracle Middleware' when LBL_PRODUCTNAME like '%Oracle BAM%' then 'SOA Suite for Oracle Middleware' when LBL_PRODUCTNAME like '%WebCenter Portal Suite 11g%' then 'Oracle WebCenter Portal' when LBL_PRODUCTNAME like '%Oracle Business Process Management%' then 'Unified Business Process Management Suite' when LBL_PRODUCTNAME like '%Oracle Remote Intradoc Client%' then 'Oracle WebCenter Content' when LBL_PRODUCTNAME like '%Oracle Application Server Guard%' then 'Internet Application Server Enterprise Edition' when LBL_PRODUCTNAME like '%Application Server Configuration%' then 'Configuration Management Pack for Internet Application Server' else LBL_PRODUCTNAME end) "Produto", LBL_BASEVERSION "Versao", LBL_PROCESSOR "Processador", lbl_virtual "VIrtual", DECODE(LBL_CPUS,null,1,LBL_CPUS) "CPUS" from (SELECT M.EXTERNAL_NAME LBL_PRODUCTNAME, M.NAME LBL_COMPONENTNAME, M.BASE_VERSION LBL_BASEVERSION, M.HOST_NAME LBL_HOSTNAME, p.virtual lbl_Virtual, p.system_config || nvl2(p.freq, p.freq || ' MHz FSB ', '') LBL_PROCESSOR, p.cpu_count LBL_CPUS FROM (MGMT$SOFTWARE_COMPONENTS M INNER JOIN mgmt$os_hw_summary p ON M.HOST_NAME = P.HOST_NAME)) where ( LBL_PRODUCTNAME like 'WebLogic Server' or LBL_PRODUCTNAME like '%WebTier and Utilities%' or LBL_PRODUCTNAME like '%EM Platform (OMS)%' or LBL_PRODUCTNAME like '%Oracle Remote Intradoc Client%' or LBL_PRODUCTNAME like '%Application Server 10g%' or LBL_PRODUCTNAME like '%Application Server Infrastructure 10g%' or LBL_PRODUCTNAME like '%Business Intelligence%' or LBL_PRODUCTNAME like '%Oracle SOA Suite%' or LBL_PRODUCTNAME like '%Oracle BAM%' or LBL_PRODUCTNAME like '%WebCenter Portal Suite 11g' or LBL_PRODUCTNAME like '%Oracle Business Process Management%' or LBL_PRODUCTNAME like '%Application Server Configuration%' or LBL_PRODUCTNAME like '%Oracle Application Server Guard%' or LBL_PRODUCTNAME like '%Oracle Remote Intradoc Client%' ) order by "Produto");
Matheus.
We even opened the first green information center in L.a.