Some more SQL script stuff. Both should work for MSSQL and Oracle.
[code]-- all installed applications (except GUIs) and their parameters and autostart options
SELECT
cfg_host.name AS "Host",
cfg_host.ip_address AS "IP",
cfg_application.name AS "App",
cfg_app_tenant.tenant_dbid AS "Tenant",
cfg_application.version AS "Version",
cfg_server.port AS "Port",
cfg_application.work_directory AS "Path",
cfg_application.command_line AS "Command Line",
cfg_application.cmd_line_args AS "Arguments",
CASE cfg_application.auto_restart
WHEN 1 THEN 'no'
WHEN 2 THEN 'yes'
ELSE 'unknown'
END AS "Auto-Restart",
cfg_application.startup_timeout AS "Startup Timeout",
CASE (
SELECT LOWER (prop_value)
FROM cfg_flex_prop
WHERE prop_name = 'autostart'
and object_dbid = cfg_application.dbid
and object_type = 9) -- CfgObjectType Application
WHEN 'true' THEN 'true'
WHEN 'false' THEN 'false'
ELSE 'null'
END AS "autostart"
FROM cfg_application
INNER JOIN cfg_app_tenant ON cfg_application.dbid = cfg_app_tenant.app_dbid
INNER JOIN cfg_server ON cfg_application.dbid = cfg_server.app_dbid
INNER JOIN cfg_host ON cfg_server.host_dbid = cfg_host.dbid
-- WHERE cfg_application.type != 8 -- Optional to omit DAPs
ORDER BY "Host", "APP"
[/code]
The next one is not from me (found it either somewhere here
) or on Genesys Knowledge Base
[code]-- all applications and their connections with ADDP parameters
SELECT
hst.name AS "Host",
appfrom.name AS "Application",
appto.name AS "Connects To",
con.conn_protocol AS "Protocol",
con.timout_local AS "Local T/O",
con.timout_remote AS "Remote T/O",
lc.lc_value AS "Trace Mode"
FROM cfg_application appfrom
INNER JOIN cfg_app_server con
ON appfrom.dbid = con.app_dbid
INNER JOIN cfg_application appto
ON con.app_server_dbid = appto.dbid
INNER JOIN cfg_server srv
ON srv.app_dbid = appfrom.dbid
INNER JOIN cfg_host hst
ON srv.host_dbid = hst.dbid
INNER JOIN cfg_locale lc
ON con.mode_ = lc.lc_subtype
WHERE
lc.lc_class = 8
AND lc.lc_type = 30
ORDER BY hst.name, appfrom.name, appto.name
[/code]
