Genesys SQL To Show Software Installed In Each Server

Following SQL can display quickly all the Genesys server software installed by hostname, version all the way to the installation directory

select c.name, a.* from cfg_application a, cfg_server b,cfg_host c

where a.dbid=b.app_dbid and b.host_dbid=c.dbid

order by c.name